explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YEcN : routing_esme_analytics

Settings
# exclusive inclusive rows x rows loops node
1. 0.532 199.157 ↑ 1.0 1,000 1

Limit (cost=0.01..477.81 rows=1,000 width=736) (actual time=0.129..199.157 rows=1,000 loops=1)

  • Buffers: shared hit=46 read=97
  • I/O Timings: read=153.533
2. 36.612 198.625 ↑ 875,500.0 1,000 1

Nested Loop (cost=0.01..418,317,167.71 rows=875,500,000 width=736) (actual time=0.127..198.625 rows=1,000 loops=1)

  • Buffers: shared hit=46 read=97
  • I/O Timings: read=153.533
3. 0.623 159.604 ↑ 10,902.9 803 1

Nested Loop (cost=0.01..265,917.70 rows=8,755,000 width=144) (actual time=0.055..159.604 rows=803 loops=1)

  • Buffers: shared hit=46 read=97
  • I/O Timings: read=153.533
4. 0.222 154.851 ↑ 148.4 590 1

Append (cost=0.00..90,817.70 rows=87,550 width=80) (actual time=0.040..154.851 rows=590 loops=1)

  • Buffers: shared hit=46 read=97
  • I/O Timings: read=153.533
5. 0.016 0.016 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
6. 154.613 154.613 ↑ 83.9 590 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.023..154.613 rows=590 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=46 read=97
  • I/O Timings: read=153.533
7. 0.000 0.000 ↓ 0.0 0

Index Scan using route_routing_1549231200_endtime_idx on routing_1549231200 (cost=0.43..39,259.95 rows=38,031 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
8. 4.130 4.130 ↑ 100.0 1 590

Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=64) (actual time=0.006..0.007 rows=1 loops=590)

9. 2.409 2.409 ↑ 100.0 1 803

Function Scan on jsonb_each pricing (cost=0.01..1.00 rows=100 width=64) (actual time=0.002..0.003 rows=1 loops=803)