explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 96eD

Settings
# exclusive inclusive rows x rows loops node
1. 541.042 286,557.132 ↑ 54.3 8,061 1

Hash Join (cost=1,003,539.98..2,628,726.53 rows=437,967 width=20) (actual time=234,748.271..286,557.132 rows=8,061 loops=1)

  • Hash Cond: (a.trip_detail_id = b.trip_detail_id)
  • Join Filter: (a.equipment_last_free_day < date(b.vessel_eta))
  • Rows Removed by Join Filter: 1289222
2. 52,154.205 286,013.154 ↑ 1.0 1,302,204 1

Bitmap Heap Scan on shipment_txn_details a (cost=1,001,477.38..2,606,718.24 rows=1,313,902 width=20) (actual time=234,735.927..286,013.154 rows=1,302,204 loops=1)

  • Recheck Cond: ((terminal_id = ANY ('{2,7,5}'::integer[])) AND ((active_record_indicator)::text = 'A'::text))
  • Filter: ((import_export_indicator)::text = 'I'::text)
  • Rows Removed by Filter: 283559
  • Heap Blocks: exact=1732175
3. 866.216 233,858.949 ↓ 0.0 0 1

BitmapAnd (cost=1,001,477.38..1,001,477.38 rows=1,837,283 width=0) (actual time=233,858.949..233,858.949 rows=0 loops=1)

4. 199,228.781 199,228.781 ↓ 2.9 36,292,063 1

Bitmap Index Scan on shipment_txn_details_terminal_id (cost=0.00..219,515.97 rows=12,549,744 width=0) (actual time=199,228.781..199,228.781 rows=36,292,063 loops=1)

  • Index Cond: (terminal_id = ANY ('{2,7,5}'::integer[]))
5. 33,763.952 33,763.952 ↓ 10.9 51,633,749 1

Bitmap Index Scan on shipment_txn_details_vessel_voyage_idx (cost=0.00..781,304.21 rows=4,748,727 width=0) (actual time=33,763.952..33,763.952 rows=51,633,749 loops=1)

  • Index Cond: ((active_record_indicator)::text = 'A'::text)
6. 0.661 2.936 ↑ 2.9 4,928 1

Hash (cost=1,881.71..1,881.71 rows=14,471 width=16) (actual time=2.936..2.936 rows=4,928 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 359kB
7. 2.275 2.275 ↑ 2.9 4,928 1

Seq Scan on trip_detail b (cost=0.00..1,881.71 rows=14,471 width=16) (actual time=0.004..2.275 rows=4,928 loops=1)

Planning time : 0.985 ms
Execution time : 286,558.175 ms