explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S0WK

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

Nested Loop Left Join (cost=11,410.44..48,308.40 rows=23 width=4) (actual time=130.086..130.086 rows=0 loops=1)

  • Filter: (lot_bids.* IS NULL)
2. 0.003 130.085 ↓ 0.0 0 1

Nested Loop (cost=11,410.01..38,365.29 rows=4,539 width=4) (actual time=130.085..130.085 rows=0 loops=1)

3. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on tender_lot_states (cost=0.00..1.14 rows=1 width=4) (actual time=0.010..0.013 rows=1 loops=1)

  • Filter: ((tender_lot_state_constant)::text = 'ON_APPROVAL'::text)
  • Rows Removed by Filter: 10
4. 14.545 130.069 ↓ 0.0 0 1

Bitmap Heap Scan on tender_lots (cost=11,410.01..38,301.74 rows=6,241 width=8) (actual time=130.069..130.069 rows=0 loops=1)

  • Recheck Cond: (tender_lot_state_id = tender_lot_states.tender_lot_state_id)
  • Filter: ((tender_lot_is_active IS TRUE) AND (NOT (hashed SubPlan 1)))
  • Rows Removed by Filter: 378
  • Heap Blocks: exact=352
5. 0.061 0.061 ↑ 36.6 378 1

Bitmap Index Scan on tender_lot_search_index_lot_state (cost=0.00..700.17 rows=13,834 width=0) (actual time=0.061..0.061 rows=378 loops=1)

  • Index Cond: (tender_lot_state_id = tender_lot_states.tender_lot_state_id)
6.          

SubPlan (for Bitmap Heap Scan)

7. 30.317 115.463 ↓ 1.4 49,238 1

Hash Join (cost=4,427.24..10,617.87 rows=36,165 width=5) (actual time=52.492..115.463 rows=49,238 loops=1)

  • Hash Cond: (event_attributes.eventid = event_core.eventid)
8. 32.767 32.767 ↓ 1.0 181,315 1

Seq Scan on event_attributes (cost=0.00..5,150.88 rows=180,827 width=9) (actual time=0.006..32.767 rows=181,315 loops=1)

  • Filter: ((attributename)::text = 'lotID'::text)
  • Rows Removed by Filter: 97395
9. 7.804 52.379 ↓ 1.3 49,276 1

Hash (cost=3,941.05..3,941.05 rows=38,895 width=4) (actual time=52.379..52.379 rows=49,276 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2245kB
10. 27.013 44.575 ↓ 1.3 49,276 1

Hash Join (cost=1.07..3,941.05 rows=38,895 width=4) (actual time=0.028..44.575 rows=49,276 loops=1)

  • Hash Cond: (event_core.eventtypelid = event_types.event_type_id)
11. 17.552 17.552 ↑ 1.0 190,974 1

Seq Scan on event_core (cost=0.00..2,996.77 rows=194,477 width=8) (actual time=0.009..17.552 rows=190,974 loops=1)

12. 0.003 0.010 ↑ 1.0 1 1

Hash (cost=1.06..1.06 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on event_types (cost=0.00..1.06 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: ((event_type_constant)::text = 'EVENT_TYPE_WINNER_NOT_APPROVED'::text)
  • Rows Removed by Filter: 4
14. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_auctionid_asc on lot_bids (cost=0.42..2.18 rows=1 width=306) (never executed)

  • Index Cond: (tender_lots.tender_lot_id = auctionid)
  • Filter: ((iswinner IS TRUE) AND (isactive IS TRUE))
Planning time : 0.962 ms
Execution time : 130.184 ms