explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tWw

Settings
# exclusive inclusive rows x rows loops node
1. 675.169 18,409.293 ↑ 1.0 1 1

Aggregate (cost=83,761.20..83,761.21 rows=1 width=8) (actual time=18,409.293..18,409.293 rows=1 loops=1)

2. 290.866 17,734.124 ↑ 1.1 1,018,646 1

Hash Semi Join (cost=2,775.36..80,844.36 rows=1,166,735 width=8) (actual time=2.250..17,734.124 rows=1,018,646 loops=1)

  • Hash Cond: (visits.deviceid = (devices.deviceid)::text)
3. 84.319 17,441.144 ↓ 1.0 1,991,976 1

Custom Scan (ConstraintAwareAppend) (cost=0.00..59,984.60 rows=1,944,558 width=13) (actual time=0.124..17,441.144 rows=1,991,976 loops=1)

  • Hypertable: visits
  • Chunks left after exclusion: 2
4. 71.220 17,356.825 ↓ 1.0 1,991,976 1

Append (cost=0.00..59,984.60 rows=1,944,558 width=13) (actual time=0.122..17,356.825 rows=1,991,976 loops=1)

5. 16,196.010 16,196.010 ↓ 1.1 470,850 1

Index Scan using _hyper_4_429_chunk_visits_time_idx on _hyper_4_429_chunk (cost=0.43..19,022.21 rows=423,869 width=13) (actual time=0.121..16,196.010 rows=470,850 loops=1)

  • Index Cond: ("time" > (now() - '7 days'::interval))
6. 1,089.595 1,089.595 ↓ 1.0 1,521,126 1

Seq Scan on _hyper_4_434_chunk (cost=0.00..40,742.27 rows=1,520,644 width=13) (actual time=0.021..1,089.595 rows=1,521,126 loops=1)

  • Filter: ("time" > (now() - '7 days'::interval))
7. 0.015 2.114 ↑ 1.0 15 1

Hash (cost=2,775.18..2,775.18 rows=15 width=9) (actual time=2.114..2.114 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 2.099 2.099 ↑ 1.0 15 1

Seq Scan on devices (cost=0.00..2,775.18 rows=15 width=9) (actual time=0.016..2.099 rows=15 loops=1)

  • Filter: (projectcode = 61076)
  • Rows Removed by Filter: 85
Planning time : 29.231 ms
Execution time : 18,427.718 ms