explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DvJd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 388.279 ↓ 0.0 0 1

GroupAggregate (cost=12,127.99..67,008.21 rows=3 width=126) (actual time=388.279..388.279 rows=0 loops=1)

  • Group Key: org.name
2. 26.166 390.844 ↓ 0.0 0 1

Gather (cost=12,127.99..67,008.16 rows=3 width=122) (actual time=388.278..390.844 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.000 364.678 ↓ 0.0 0 3 / 3

Nested Loop (cost=11,127.99..66,007.86 rows=1 width=122) (actual time=364.678..364.678 rows=0 loops=3)

4. 0.068 364.678 ↓ 0.0 0 3 / 3

Hash Join (cost=11,127.86..66,007.09 rows=5 width=126) (actual time=364.678..364.678 rows=0 loops=3)

  • Hash Cond: (usage_fact.org_id = org.organisation_id)
5. 171.823 364.435 ↓ 0.0 0 3 / 3

Hash Join (cost=11,098.80..65,975.06 rows=1,128 width=12) (actual time=364.435..364.435 rows=0 loops=3)

  • Hash Cond: (usage_fact.date_id = date_dim.date_id)
6. 109.325 109.325 ↑ 1.2 1,253,286 3 / 3

Parallel Seq Scan on usage_fact (cost=0.00..50,764.34 rows=1,566,434 width=36) (actual time=0.004..109.325 rows=1,253,286 loops=3)

7. 0.131 83.287 ↓ 1.2 385 3 / 3

Hash (cost=11,094.69..11,094.69 rows=328 width=8) (actual time=83.287..83.287 rows=385 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
8. 83.156 83.156 ↓ 1.2 385 3 / 3

Seq Scan on date_dim (cost=0.00..11,094.69 rows=328 width=8) (actual time=13.822..83.156 rows=385 loops=3)

  • Filter: ((date >= '2020-05-01 00:00:00'::timestamp without time zone) AND (date <= '2020-05-05 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 455328
9. 0.004 0.175 ↑ 4.0 1 3 / 3

Hash (cost=29.01..29.01 rows=4 width=122) (actual time=0.175..0.175 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.171 0.171 ↑ 4.0 1 3 / 3

Seq Scan on organisation org (cost=0.00..29.01 rows=4 width=122) (actual time=0.121..0.171 rows=1 loops=3)

  • Filter: ((name)::text = 'Hertfordshire'::text)
  • Rows Removed by Filter: 675
11. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using app_dim_pk on app_dim (cost=0.13..0.15 rows=1 width=4) (never executed)

  • Index Cond: (id = usage_fact.app_id)
  • Filter: ((app)::text = 'TM'::text)
Planning time : 0.595 ms
Execution time : 390.910 ms