explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DAGj

Settings
# exclusive inclusive rows x rows loops node
1. 1.361 757.961 ↑ 78.9 29 1

GroupAggregate (cost=14,213.55..14,322.19 rows=2,287 width=112) (actual time=756.400..757.961 rows=29 loops=1)

  • Group Key: (('1970-01-01 01:00:00+01'::timestamp with time zone + ('24:00:00'::interval * (((date_part('epoch'::text, sounds.recorded_at))::integer / 86400))::double precision))), hives.id
2. 2.253 756.600 ↓ 1.4 3,094 1

Sort (cost=14,213.55..14,219.27 rows=2,287 width=40) (actual time=756.258..756.600 rows=3,094 loops=1)

  • Sort Key: (('1970-01-01 01:00:00+01'::timestamp with time zone + ('24:00:00'::interval * (((date_part('epoch'::text, sounds.recorded_at))::integer / 86400))::double precision)))
  • Sort Method: quicksort Memory: 338kB
3. 1.131 754.347 ↓ 1.4 3,094 1

Nested Loop (cost=5,954.27..14,085.95 rows=2,287 width=40) (actual time=473.701..754.347 rows=3,094 loops=1)

4. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on hives (cost=0.00..1.62 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (id = 25)
  • Rows Removed by Filter: 49
5. 5.416 753.206 ↓ 1.4 3,094 1

Gather (cost=5,954.27..14,027.15 rows=2,287 width=40) (actual time=473.676..753.206 rows=3,094 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 69.819 747.790 ↓ 1.1 1,031 3 / 3

Parallel Hash Join (cost=4,954.27..12,798.45 rows=953 width=40) (actual time=515.124..747.790 rows=1,031 loops=3)

  • Hash Cond: (sound_features_monotonous_coefficients.sound_id = sounds.id)
7. 583.553 583.553 ↑ 1.3 180,922 3 / 3

Parallel Seq Scan on sound_features_monotonous_coefficients (cost=0.00..7,250.53 rows=226,153 width=32) (actual time=1.112..583.553 rows=180,922 loops=3)

8. 1.789 94.418 ↑ 1.3 1,031 3 / 3

Parallel Hash (cost=4,937.30..4,937.30 rows=1,357 width=24) (actual time=94.418..94.418 rows=1,031 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 224kB
9. 91.529 92.629 ↑ 1.3 1,031 3 / 3

Parallel Bitmap Heap Scan on sounds (cost=65.84..4,937.30 rows=1,357 width=24) (actual time=1.445..92.629 rows=1,031 loops=3)

  • Recheck Cond: ((hive_id = 25) AND (recorded_at >= '2020-01-01 00:00:00'::timestamp without time zone) AND (recorded_at <= '2020-01-30 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=343
10. 1.100 1.100 ↓ 1.3 3,094 1 / 3

Bitmap Index Scan on index_sounds_on_hive_id_and_recorded_at (cost=0.00..65.26 rows=2,307 width=0) (actual time=3.300..3.300 rows=3,094 loops=1)

  • Index Cond: ((hive_id = 25) AND (recorded_at >= '2020-01-01 00:00:00'::timestamp without time zone) AND (recorded_at <= '2020-01-30 00:00:00'::timestamp without time zone))
Planning time : 0.306 ms
Execution time : 759.504 ms