explain.depesz.com

PostgreSQL's explain analyze made readable

Result: puHw : chnages_analytics3

Settings
# exclusive inclusive rows x rows loops node
1. 0.383 3.973 ↑ 1.0 1,000 1
→

Limit (cost=0.00..66.88 rows=1,000 width=272) (actual time=0.147..3.973 rows=1,000 loops=1)

  • Buffers: shared hit=40
2. 2.203 3.590 ↑ 10.3 1,000 1
→

Nested Loop (cost=0.00..688.88 rows=10,300 width=272) (actual time=0.145..3.590 rows=1,000 loops=1)

  • Buffers: shared hit=40
3. 0.146 0.523 ↓ 4.2 432 1
→

Append (cost=0.00..96.63 rows=103 width=80) (actual time=0.123..0.523 rows=432 loops=1)

  • Buffers: shared hit=40
4. 0.015 0.015 ↓ 0.0 0 1
→

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 0.269 0.362 ↓ 6.9 432 1
→

Bitmap Heap Scan on changes_1549144800 (cost=2.03..59.31 rows=63 width=80) (actual time=0.107..0.362 rows=432 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=34
  • Buffers: shared hit=40
6. 0.093 0.093 ↓ 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.093..0.093 rows=1,544 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=6
7. 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))
8. 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))
9. 0.864 0.864 ↑ 50.0 2 432
→

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