explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QVYF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,072.641 ↑ 280.8 18 1

Limit (cost=3,345.54..126,267.53 rows=5,055 width=386) (actual time=179.634..2,072.641 rows=18 loops=1)

2. 51.654 2,116.963 ↑ 280.8 18 1

Gather (cost=3,345.54..126,267.53 rows=5,055 width=386) (actual time=179.632..2,116.963 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.531 2,065.309 ↑ 351.0 6 3 / 3

Parallel Hash Join (cost=2,345.54..124,762.03 rows=2,106 width=386) (actual time=809.638..2,065.309 rows=6 loops=3)

  • Hash Cond: (nedr.nacha_file_id = nf.id)
4. 2,021.349 2,021.349 ↑ 162.1 13 3 / 3

Parallel Seq Scan on nacha_entry_detail_records nedr (cost=0.00..122,410.96 rows=2,107 width=382) (actual time=763.349..2,021.349 rows=13 loops=3)

  • Filter: ((eft_instruction_id IS NULL) AND (is_recon_prepped <> 1) AND (is_intermediary = 1))
  • Rows Removed by Filter: 892,945
5. 4.536 43.429 ↑ 1.8 12,252 3 / 3

Parallel Hash (cost=2,075.26..2,075.26 rows=21,622 width=8) (actual time=43.429..43.429 rows=12,252 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,984kB
6. 38.893 38.893 ↑ 1.8 12,252 3 / 3

Parallel Seq Scan on nacha_files nf (cost=0.00..2,075.26 rows=21,622 width=8) (actual time=0.211..38.893 rows=12,252 loops=3)

  • Filter: (confirmed_on IS NOT NULL)
  • Rows Removed by Filter: 3
Planning time : 12.500 ms
Execution time : 2,117.054 ms