explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AFri

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.055 ↓ 0.0 0 1

Limit (cost=28,624.86..28,624.86 rows=1 width=16) (actual time=0.055..0.055 rows=0 loops=1)

2. 0.033 0.054 ↓ 0.0 0 1

Sort (cost=28,624.86..28,625.36 rows=200 width=16) (actual time=0.054..0.054 rows=0 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.021 ↓ 0.0 0 1

HashAggregate (cost=28,618.36..28,623.86 rows=200 width=16) (actual time=0.021..0.021 rows=0 loops=1)

  • Group Key: (date_trunc('hour'::text, x.entry) + ((((date_part('minute'::text, x.entry))::integer / 30))::double precision * '00:30:00'::interval))
4. 0.001 0.020 ↓ 0.0 0 1

Subquery Scan on x (cost=8,818.18..26,228.36 rows=478,000 width=8) (actual time=0.020..0.020 rows=0 loops=1)

5. 0.000 0.019 ↓ 0.0 0 1

ProjectSet (cost=8,818.18..13,083.36 rows=478,000 width=8) (actual time=0.019..0.019 rows=0 loops=1)

6. 0.001 0.019 ↓ 0.0 0 1

Bitmap Heap Scan on checkin c (cost=8,818.18..10,689.77 rows=478 width=16) (actual time=0.019..0.019 rows=0 loops=1)

  • Recheck Cond: ((fk_organization_unit = 1,210,001,590) AND (checkin_time >= '2020-01-28 00:00:00+00'::timestamp with time zone) AND (checkin_time <= '2020-01-29 00:00:00+00'::timestamp with time zone))
7. 0.000 0.018 ↓ 0.0 0 1

BitmapAnd (cost=8,818.18..8,818.18 rows=478 width=0) (actual time=0.018..0.018 rows=0 loops=1)

8. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on checkin_fk_organization_unit_idx (cost=0.00..2,175.22 rows=64,887 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (fk_organization_unit = 1,210,001,590)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on checkin_checkin_time_idx (cost=0.00..6,642.47 rows=156,991 width=0) (never executed)

  • Index Cond: ((checkin_time >= '2020-01-28 00:00:00+00'::timestamp with time zone) AND (checkin_time <= '2020-01-29 00:00:00+00'::timestamp with time zone))
Planning time : 0.629 ms
Execution time : 0.192 ms