explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lV62

Settings
# exclusive inclusive rows x rows loops node
1. 668.026 987.913 ↑ 35.6 12,150 1

Hash Join (cost=58,674.21..117,348.06 rows=432,600 width=178) (actual time=293.399..987.913 rows=12,150 loops=1)

  • Hash Cond: (waypoint.order_id = o.id)
2. 3.972 26.939 ↑ 35.6 12,150 1

Nested Loop (cost=0.42..9,214.66 rows=432,600 width=50) (actual time=0.064..26.939 rows=12,150 loops=1)

3. 1.176 11.819 ↓ 2.6 11,148 1

Append (cost=0.42..562.66 rows=4,326 width=79) (actual time=0.056..11.819 rows=11,148 loops=1)

4. 10.643 10.643 ↓ 2.6 11,148 1

Index Scan using _hyper_38_426_chunk_itinerary_stop_position_ts_idx on _hyper_38_426_chunk s (cost=0.42..541.03 rows=4,326 width=79) (actual time=0.056..10.643 rows=11,148 loops=1)

  • Index Cond: (position_ts >= '2020-10-12 00:00:00'::timestamp without time zone)
  • Filter: (leg_index IS NOT NULL)
  • Rows Removed by Filter: 7,687
5. 11.148 11.148 ↑ 100.0 1 11,148

Function Scan on unnest waypoint (cost=0.00..1.00 rows=100 width=36) (actual time=0.001..0.001 rows=1 loops=11,148)

6. 199.786 292.948 ↑ 1.0 162,454 1

Hash (cost=38,326.02..38,326.02 rows=168,302 width=859) (actual time=292.947..292.948 rows=162,454 loops=1)

  • Buckets: 32,768 Batches: 8 Memory Usage: 18,090kB
7. 93.162 93.162 ↑ 1.0 162,454 1

Seq Scan on es_order o (cost=0.00..38,326.02 rows=168,302 width=859) (actual time=0.008..93.162 rows=162,454 loops=1)

Planning time : 0.500 ms
Execution time : 988.969 ms