query-9033734ee5453c40bf168699e15e5386ba434393d9b7c73e65c73405784a0931.json
1 { 2 "db_name": "PostgreSQL", 3 "query": "\nDELETE\nFROM password_reset\nWHERE created_at + ($1 * interval '1 minute') < NOW()\nRETURNING id, login_details, code, created_at, modified_at\n ", 4 "describe": { 5 "columns": [ 6 { 7 "ordinal": 0, 8 "name": "id", 9 "type_info": "Uuid" 10 }, 11 { 12 "ordinal": 1, 13 "name": "login_details", 14 "type_info": "Uuid" 15 }, 16 { 17 "ordinal": 2, 18 "name": "code", 19 "type_info": "Uuid" 20 }, 21 { 22 "ordinal": 3, 23 "name": "created_at", 24 "type_info": "Timestamptz" 25 }, 26 { 27 "ordinal": 4, 28 "name": "modified_at", 29 "type_info": "Timestamptz" 30 } 31 ], 32 "parameters": { 33 "Left": [ 34 "Float8" 35 ] 36 }, 37 "nullable": [ 38 false, 39 false, 40 false, 41 false, 42 false 43 ] 44 }, 45 "hash": "9033734ee5453c40bf168699e15e5386ba434393d9b7c73e65c73405784a0931" 46 }