explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qToZ : chnages_analytics

Settings
# exclusive inclusive rows x rows loops node
1. 0.296 3.975 ↑ 1.0 1,000 1

Limit (cost=0.00..67.87 rows=1,000 width=272) (actual time=0.136..3.975 rows=1,000 loops=1)

  • Buffers: shared hit=19
2. 2.191 3.679 ↑ 1,030.0 1,000 1

Result (cost=0.00..69,904.88 rows=1,030,000 width=272) (actual time=0.135..3.679 rows=1,000 loops=1)

  • Buffers: shared hit=19
3. 0.677 1.488 ↑ 1,030.0 1,000 1

ProjectSet (cost=0.00..5,529.88 rows=1,030,000 width=112) (actual time=0.126..1.488 rows=1,000 loops=1)

  • Buffers: shared hit=19
4. 0.194 0.811 ↑ 30.7 335 1

Nested Loop (cost=0.00..302.63 rows=10,300 width=112) (actual time=0.123..0.811 rows=335 loops=1)

  • Buffers: shared hit=19
5. 0.048 0.305 ↓ 1.5 156 1

Append (cost=0.00..96.63 rows=103 width=80) (actual time=0.110..0.305 rows=156 loops=1)

  • Buffers: shared hit=19
6. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 0.162 0.242 ↓ 2.5 156 1

Bitmap Heap Scan on changes_1549144800 (cost=2.03..59.31 rows=63 width=80) (actual time=0.094..0.242 rows=156 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=13
  • Buffers: shared hit=19
8. 0.080 0.080 ↓ 24.5 1,544 1

Bitmap Index Scan on route_changes_1549144800_endtime_idx (cost=0.00..2.01 rows=63 width=0) (actual time=0.080..0.080 rows=1,544 loops=1)

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

Bitmap Heap Scan on changes_1549231200 (cost=1.78..36.81 rows=39 width=80) (never executed)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on route_changes_1549231200_endtime_idx (cost=0.00..1.77 rows=39 width=0) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
11. 0.312 0.312 ↑ 50.0 2 156

Function Scan on jsonb_array_elements act (cost=0.00..1.00 rows=100 width=32) (actual time=0.001..0.002 rows=2 loops=156)