explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8oil

Settings
# exclusive inclusive rows x rows loops node
1. 0.565 29,602.812 ↓ 0.0 0 1

Gather Merge (cost=1,033,094.20..1,033,109.52 rows=128 width=8) (actual time=29,602.702..29,602.812 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
2. 0.010 29,602.247 ↓ 0.0 0 1

Sort (cost=1,032,094.14..1,032,094.22 rows=32 width=8) (actual time=29,602.247..29,602.247 rows=0 loops=1)

  • Sort Key: date DESC, id DESC
  • Sort Method: quicksort Memory: 25kB
3. 29,602.237 29,602.237 ↓ 0.0 0 1

Parallel Seq Scan on account_move_line (cost=0.00..1,032,093.34 rows=32 width=8) (actual time=29,602.237..29,602.237 rows=0 loops=1)

  • Filter: (((id <> ALL ('{36093958,35057544}'::integer[])) OR (id IS NULL)) AND ((company_id IS NULL) OR (company_id = 1)) AND (full_reconcile_id = 22,738))
  • Rows Removed by Filter: 33,412,435
Planning time : 0.280 ms
Execution time : 29,602.861 ms