explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pk2g

Settings
# exclusive inclusive rows x rows loops node
1. 175.104 409.472 ↓ 0.0 0 1

Delete on port_call_history (cost=72.92..620,416.34 rows=163,550 width=34) (actual time=409.472..409.472 rows=0 loops=1)

2. 4.250 234.368 ↑ 3.7 44,180 1

Nested Loop (cost=72.92..620,416.34 rows=163,550 width=34) (actual time=0.189..234.368 rows=44,180 loops=1)

3. 0.080 0.218 ↑ 1.0 100 1

HashAggregate (cost=72.35..73.35 rows=100 width=32) (actual time=0.162..0.218 rows=100 loops=1)

  • Group Key: "ANY_subquery".id
4. 0.019 0.138 ↑ 1.0 100 1

Subquery Scan on ANY_subquery (cost=0.43..72.10 rows=100 width=32) (actual time=0.021..0.138 rows=100 loops=1)

5. 0.008 0.119 ↑ 1.0 100 1

Limit (cost=0.43..71.10 rows=100 width=4) (actual time=0.017..0.119 rows=100 loops=1)

6. 0.009 0.111 ↑ 7,656.7 100 1

Nested Loop (cost=0.43..541,127.66 rows=765,668 width=4) (actual time=0.016..0.111 rows=100 loops=1)

7. 0.006 0.006 ↑ 5,620.0 1 1

Seq Scan on vessel (cost=0.00..1,062.67 rows=5,620 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (dead_weight <= 60000)
8. 0.096 0.096 ↑ 1.9 100 1

Index Scan using ix_port_call_vessel_id on port_call (cost=0.43..94.23 rows=187 width=8) (actual time=0.010..0.096 rows=100 loops=1)

  • Index Cond: (vessel_id = vessel.id)
9. 229.900 229.900 ↑ 3.7 442 100

Index Scan using ix_port_call_history_port_call_id on port_call_history (cost=0.57..6,187.07 rows=1,636 width=10) (actual time=0.011..2.299 rows=442 loops=100)

  • Index Cond: (port_call_id = "ANY_subquery".id)
Planning time : 0.815 ms
Execution time : 409.538 ms