explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ymf : conversion_rundata_inner

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4,305.914 4,530.253 ↓ 25,941.0 25,941 1

Nested Loop (cost=0.01..13.07 rows=1 width=864) (actual time=0.622..4,530.253 rows=25,941 loops=1)

  • Buffers: shared hit=19124 read=4
  • I/O Timings: read=0.056
2. 9.173 47.048 ↓ 19,699.0 19,699 1

Nested Loop (cost=0.00..10.56 rows=1 width=1,238) (actual time=0.061..47.048 rows=19,699 loops=1)

  • Buffers: shared hit=4212
3. 0.033 0.255 ↓ 20.0 60 1

Append (cost=0.00..2.54 rows=3 width=179) (actual time=0.038..0.255 rows=60 loops=1)

  • Buffers: shared hit=62
4. 0.025 0.025 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
5. 0.197 0.197 ↓ 30.0 60 1

Index Scan using route_rundata_1549317600_endtime_idx on rundata_1549317600 (cost=0.28..2.52 rows=2 width=228) (actual time=0.011..0.197 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=62
6. 7.620 37.620 ↓ 164.0 328 60

Append (cost=0.00..2.65 rows=2 width=1,059) (actual time=0.015..0.627 rows=328 loops=60)

  • Buffers: shared hit=4150
7. 0.000 0.000 ↓ 0.0 0 60

Seq Scan on conversion c (cost=0.00..0.00 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=60)

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137) AND (rundata.endtime = endtime))
8. 30.000 30.000 ↓ 328.0 328 60

Index Scan using route_conversion_1549317600_endtime_idx on conversion_1549317600 c_1 (cost=0.42..2.65 rows=1 width=1,063) (actual time=0.010..0.500 rows=328 loops=60)

  • Index Cond: ((endtime = rundata.endtime) AND (endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=4150
9. 177.291 177.291 ↑ 100.0 1 19,699

Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=64) (actual time=0.008..0.009 rows=1 loops=19,699)

  • Buffers: shared hit=988 read=4
  • I/O Timings: read=0.056