explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CWDJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.930 5.665 ↑ 1.0 48 1

Sort (cost=179.51..179.63 rows=48 width=46) (actual time=5.213..5.665 rows=48 loops=1)

  • Sort Key: _hyper_2_4_chunk.ts
  • Sort Method: quicksort Memory: 31kB
2. 1.037 4.735 ↑ 1.0 48 1

Nested Loop (cost=5.87..178.17 rows=48 width=46) (actual time=0.439..4.735 rows=48 loops=1)

3. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on location (cost=0.00..1.98 rows=1 width=18) (actual time=0.013..0.031 rows=1 loops=1)

  • Filter: (id = 27)
  • Rows Removed by Filter: 77
4. 1.065 3.667 ↑ 1.0 48 1

Nested Loop (cost=5.87..175.71 rows=48 width=44) (actual time=0.397..3.667 rows=48 loops=1)

5. 0.153 0.338 ↑ 1.0 1 1

Hash Join (cost=1.09..2.25 rows=1 width=25) (actual time=0.307..0.338 rows=1 loops=1)

  • Hash Cond: (unit.id = measure.unit)
6. 0.125 0.125 ↑ 1.0 12 1

Seq Scan on unit (cost=0.00..1.12 rows=12 width=11) (actual time=0.011..0.125 rows=12 loops=1)

7. 0.029 0.060 ↑ 1.0 1 1

Hash (cost=1.07..1.07 rows=1 width=30) (actual time=0.052..0.060 rows=1 loops=1)

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

Seq Scan on measure (cost=0.00..1.07 rows=1 width=30) (actual time=0.014..0.031 rows=1 loops=1)

  • Filter: (id = 3)
  • Rows Removed by Filter: 5
9. 0.917 2.264 ↑ 1.0 48 1

Append (cost=4.78..172.98 rows=48 width=35) (actual time=0.057..2.264 rows=48 loops=1)

10. 0.330 0.355 ↑ 1.0 24 1

Bitmap Heap Scan on _hyper_2_4_chunk (cost=4.78..86.92 rows=24 width=35) (actual time=0.037..0.355 rows=24 loops=1)

  • Recheck Cond: ((location = 27) AND (measure = 3) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
  • Heap Blocks: exact=24
11. 0.025 0.025 ↑ 1.0 24 1

Bitmap Index Scan on _hyper_2_4_chunk_idx_datamart_measurement_location_measure_ts (cost=0.00..4.78 rows=24 width=0) (actual time=0.017..0.025 rows=24 loops=1)

  • Index Cond: ((location = 27) AND (measure = 3) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
12. 0.956 0.992 ↑ 1.0 24 1

Bitmap Heap Scan on _hyper_2_2_chunk (cost=4.78..85.82 rows=24 width=35) (actual time=0.141..0.992 rows=24 loops=1)

  • Recheck Cond: ((location = 27) AND (measure = 3) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
  • Heap Blocks: exact=24
13. 0.036 0.036 ↑ 1.0 24 1

Bitmap Index Scan on _hyper_2_2_chunk_idx_datamart_measurement_location_measure_ts (cost=0.00..4.78 rows=24 width=0) (actual time=0.028..0.036 rows=24 loops=1)

  • Index Cond: ((location = 27) AND (measure = 3) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
Planning time : 1.063 ms
Execution time : 6.323 ms