explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 57nT

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 435.268 ↓ 0.0 0 1

Sort (cost=1,330.78..1,330.78 rows=1 width=4) (actual time=432.889..435.268 rows=0 loops=1)

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

Gather (cost=10.00..1,330.77 rows=1 width=4) (actual time=432.826..435.204 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 254.705 254.705 ↓ 0.0 0 3 / 3

Parallel Seq Scan on voucher_importer_error (cost=0.00..1,320.76 rows=1 width=4) (actual time=254.704..254.705 rows=0 loops=3)

  • Filter: (is_duplicated AND ((code)::text = '500175969'::text) AND (parent_id = 4,127))
  • Rows Removed by Filter: 49,268
Planning time : 361.415 ms
Execution time : 435.371 ms