explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HS1E : routing_route_analytics

Settings
# exclusive inclusive rows x rows loops node
1. 0.548 76.829 ↑ 1.0 1,000 1

Limit (cost=0.01..420.38 rows=1,000 width=868) (actual time=0.244..76.829 rows=1,000 loops=1)

  • Buffers: shared hit=106
2. 72.492 76.281 ↑ 8,917.6 1,000 1

Nested Loop (cost=0.01..3,748,721.05 rows=8,917,600 width=868) (actual time=0.243..76.281 rows=1,000 loops=1)

  • Buffers: shared hit=106
3. 0.151 0.807 ↑ 209.3 426 1

Append (cost=0.00..92,505.05 rows=89,176 width=80) (actual time=0.040..0.807 rows=426 loops=1)

  • Buffers: shared hit=106
4. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on routing (cost=0.00..0.00 rows=1 width=80) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 0.637 0.637 ↑ 116.2 426 1

Index Scan using route_routing_1549144800_endtime_idx on routing_1549144800 (cost=0.43..51,120.00 rows=49,518 width=80) (actual time=0.019..0.637 rows=426 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=106
6. 0.000 0.000 ↓ 0.0 0

Index Scan using route_routing_1549231200_endtime_idx on routing_1549231200 (cost=0.43..40,939.17 rows=39,657 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 2.982 2.982 ↑ 50.0 2 426

Function Scan on jsonb_each pricing (cost=0.01..1.00 rows=100 width=64) (actual time=0.006..0.007 rows=2 loops=426)