explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9uVt

Settings
# exclusive inclusive rows x rows loops node
1. 11,568.895 53,956.649 ↑ 1.0 50,842,028 1

Hash Join (cost=1,583.18..4,563,513.29 rows=51,177,090 width=82) (actual time=0.100..53,956.649 rows=50,842,028 loops=1)

  • Hash Cond: (gd.property_id = load_prop.property_id)
2. 16,268.778 42,387.689 ↑ 1.0 50,852,100 1

Merge Join (cost=1,575.59..3,859,820.72 rows=51,177,090 width=51) (actual time=0.023..42,387.689 rows=50,852,100 loops=1)

  • Merge Cond: (gd.gl_header_id = gh.id)
3. 15,108.612 15,108.612 ↑ 1.0 51,186,517 1

Index Scan using idx_gl_details_gl_header_id on gl_details gd (cost=0.56..1,838,758.08 rows=51,197,568 width=38) (actual time=0.011..15,108.612 rows=51,186,517 loops=1)

  • Filter: (cid = 13,531)
4. 11,010.299 11,010.299 ↑ 1.0 24,069,881 1

Index Scan using idx_gl_headers_id on gl_headers gh (cost=0.44..1,321,166.31 rows=24,076,930 width=25) (actual time=0.010..11,010.299 rows=24,069,881 loops=1)

  • Filter: ((NOT is_template) AND (cid = 13,531) AND (gl_book_id = 144) AND ((gl_header_status_type_id <> ALL ('{4,5,6}'::integer[])) OR ((gl_transaction_type_id = 1) AND (gl_header_status_type_id = 2))))
  • Rows Removed by Filter: 9,687
5. 0.037 0.065 ↑ 1.0 204 1

Hash (cost=5.04..5.04 rows=204 width=35) (actual time=0.065..0.065 rows=204 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
6. 0.028 0.028 ↑ 1.0 204 1

Seq Scan on load_prop (cost=0.00..5.04 rows=204 width=35) (actual time=0.005..0.028 rows=204 loops=1)

Planning time : 1.911 ms
Execution time : 78,856.870 ms