explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ve4j

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

Delete on gl_headers gh (cost=0.87..60,235.60 rows=1 width=12) (actual time=48.410..48.410 rows=0 loops=1)

2. 0.002 48.409 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.87..60,235.60 rows=1 width=12) (actual time=48.409..48.409 rows=0 loops=1)

3. 48.398 48.398 ↑ 1.0 1 1

Index Scan using idx_gl_headers_gl_transaction_type_id on gl_headers gh (cost=0.43..60,233.34 rows=1 width=14) (actual time=0.017..48.398 rows=1 loops=1)

  • Index Cond: (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.009 0.009 ↑ 13.0 1 1

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

  • Index Cond: ((gh.cid = cid) AND (gh.id = gl_header_id))
Planning time : 0.488 ms
Execution time : 48.451 ms