explain.depesz.com

PostgreSQL's explain analyze made readable

Result: exjp

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.033 ↓ 0.0 0 1

Sort (cost=0.74..0.74 rows=1 width=4) (actual time=0.033..0.033 rows=0 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
2. 0.024 0.024 ↓ 0.0 0 1

Index Scan using voucher_importer_error_code_idx on voucher_importer_error (cost=0.42..0.73 rows=1 width=4) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ((code)::text = '500175969'::text)
  • Filter: (is_duplicated AND (parent_id = 4,127))
Planning time : 0.324 ms
Execution time : 0.065 ms