explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xECJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.181 844.392 ↑ 1.0 1 1

Aggregate (cost=175,909.83..175,909.84 rows=1 width=8) (actual time=844.391..844.392 rows=1 loops=1)

2. 229.322 844.211 ↑ 10.6 602 1

Hash Join (cost=113,849.11..175,893.90 rows=6,373 width=0) (actual time=159.796..844.211 rows=602 loops=1)

  • Hash Cond: (tickets_ticket.order_item_id = orders_orderitem.order_item_id)
3. 461.683 461.683 ↑ 1.0 789,333 1

Seq Scan on tickets_ticket (cost=0.00..52,070.39 rows=790,051 width=4) (actual time=0.008..461.683 rows=789,333 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 15990
4. 36.957 153.206 ↑ 1.0 122,425 1

Hash (cost=112,305.94..112,305.94 rows=123,454 width=4) (actual time=153.206..153.206 rows=122,425 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5329kB
5. 116.249 116.249 ↑ 1.0 122,425 1

Index Scan using orders_orderitem_da0e2ea6 on orders_orderitem (cost=0.43..112,305.94 rows=123,454 width=4) (actual time=0.018..116.249 rows=122,425 loops=1)

  • Index Cond: (hotel_id = 40)