explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 97UQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 53.920 ↓ 0.0 0 1

Delete on gl_headers gh (cost=0.87..32,308.82 rows=1 width=12) (actual time=53.920..53.920 rows=0 loops=1)

2. 0.005 53.919 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.87..32,308.82 rows=1 width=12) (actual time=53.919..53.919 rows=0 loops=1)

3. 53.901 53.901 ↑ 1.0 1 1

Index Scan using idx_gl_headers_cid_gl_transaction_type_id_post_month_reference_ on gl_headers gh (cost=0.43..32,306.55 rows=1 width=14) (actual time=51.526..53.901 rows=1 loops=1)

  • Index Cond: ((cid = 2342) AND (gl_transaction_type_id = 1))
  • Filter: ((gl_header_type_id = ANY ('{3,4}'::integer[])) AND (created_on = now()))
  • Rows Removed by Filter: 74037
4. 0.013 0.013 ↑ 13.0 1 1

Index Scan using idx_gl_details_cid_gl_header_id on gl_details gd (cost=0.43..8.70 rows=13 width=14) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((gh.cid = cid) AND (cid = 2342) AND (gh.id = gl_header_id))
Planning time : 0.501 ms
Execution time : 53.961 ms