explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oymg

Settings
# exclusive inclusive rows x rows loops node
1. 4,502.290 5,003.351 ↑ 105.6 87,751 1

Hash Join (cost=58,675.89..1,116,436.23 rows=9,264,900 width=126) (actual time=276.851..5,003.351 rows=87,751 loops=1)

  • Hash Cond: (waypoint.order_id = o.id)
2. 17.180 224.927 ↑ 105.6 87,751 1

Nested Loop (cost=0.00..195,827.87 rows=9,264,900 width=70) (actual time=0.071..224.927 rows=87,751 loops=1)

3. 9.702 114.762 ↓ 1.0 92,985 1

Append (cost=0.00..10,529.87 rows=92,649 width=99) (actual time=0.065..114.762 rows=92,985 loops=1)

4. 75.182 75.182 ↓ 1.0 68,993 1

Seq Scan on _hyper_38_426_chunk s (cost=0.00..7,273.84 rows=68,795 width=99) (actual time=0.065..75.182 rows=68,993 loops=1)

  • Filter: ((leg_index IS NOT NULL) AND (position_ts >= '2020-10-05 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 62,048
5. 29.878 29.878 ↓ 1.0 23,992 1

Index Scan using _hyper_38_416_chunk_itinerary_stop_position_ts_idx on _hyper_38_416_chunk s_1 (cost=0.29..2,792.79 rows=23,854 width=99) (actual time=1.694..29.878 rows=23,992 loops=1)

  • Index Cond: (position_ts >= '2020-10-05 00:00:00'::timestamp without time zone)
  • Filter: (leg_index IS NOT NULL)
  • Rows Removed by Filter: 20,977
6. 92.985 92.985 ↑ 100.0 1 92,985

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

7. 189.877 276.134 ↑ 1.0 162,460 1

Hash (cost=38,327.06..38,327.06 rows=168,306 width=859) (actual time=276.133..276.134 rows=162,460 loops=1)

  • Buckets: 32,768 Batches: 8 Memory Usage: 18,091kB
8. 86.257 86.257 ↑ 1.0 162,460 1

Seq Scan on es_order o (cost=0.00..38,327.06 rows=168,306 width=859) (actual time=0.004..86.257 rows=162,460 loops=1)

Planning time : 0.539 ms
Execution time : 5,009.380 ms