explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TcbE : conversion_query

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.325 8.298 ↑ 1.0 1 1

Aggregate (cost=36.72..36.73 rows=1 width=16) (actual time=8.298..8.298 rows=1 loops=1)

  • Buffers: shared hit=191
2. 0.351 7.973 ↑ 1.0 1,000 1

Limit (cost=0.01..21.72 rows=1,000 width=8) (actual time=0.114..7.973 rows=1,000 loops=1)

  • Buffers: shared hit=191
3. 0.913 7.622 ↑ 25.7 1,000 1

Nested Loop (cost=0.01..558.04 rows=25,700 width=8) (actual time=0.112..7.622 rows=1,000 loops=1)

  • Buffers: shared hit=191
4. 0.263 1.326 ↓ 3.0 769 1

Append (cost=0.00..44.04 rows=257 width=1,038) (actual time=0.046..1.326 rows=769 loops=1)

  • Buffers: shared hit=153
5. 0.025 0.025 ↓ 0.0 0 1

Seq Scan on conversion c (cost=0.00..0.00 rows=1 width=40) (actual time=0.024..0.025 rows=0 loops=1)

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
6. 1.038 1.038 ↓ 3.0 769 1

Index Scan using route_conversion_1549317600_endtime_idx on conversion_1549317600 c_1 (cost=0.42..42.75 rows=256 width=1,042) (actual time=0.021..1.038 rows=769 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=153
7. 5.383 5.383 ↑ 100.0 1 769

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

  • Buffers: shared hit=38