explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c4Hu

Settings
# exclusive inclusive rows x rows loops node
1. 315.151 2,005.772 ↑ 1.0 423,444 1

Hash Join (cost=67,822.09..109,030.24 rows=423,444 width=24) (actual time=1,027.443..2,005.772 rows=423,444 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
2. 555.895 1,212.059 ↑ 1.0 423,444 1

Hash Join (cost=34,622.22..65,715.02 rows=423,444 width=8) (actual time=548.795..1,212.059 rows=423,444 loops=1)

  • Hash Cond: (claims.events_id = events_venues.events_id)
3. 107.628 107.628 ↑ 1.0 423,444 1

Seq Scan on claims (cost=0.00..17,822.44 rows=423,444 width=4) (actual time=0.013..107.628 rows=423,444 loops=1)

4. 279.716 548.536 ↑ 1.0 1,059,210 1

Hash (cost=17,244.10..17,244.10 rows=1,059,210 width=8) (actual time=548.535..548.536 rows=1,059,210 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3630kB
5. 268.820 268.820 ↑ 1.0 1,059,210 1

Seq Scan on events_venues (cost=0.00..17,244.10 rows=1,059,210 width=8) (actual time=0.009..268.820 rows=1,059,210 loops=1)

6. 46.882 478.562 ↑ 1.0 167,589 1

Hash (cost=30,120.27..30,120.27 rows=167,728 width=20) (actual time=478.562..478.562 rows=167,589 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2735kB
7. 268.048 431.680 ↑ 1.0 167,589 1

Hash Join (cost=5,875.88..30,120.27 rows=167,728 width=20) (actual time=70.244..431.680 rows=167,589 loops=1)

  • Hash Cond: (venues.id = venues_profiles.venues_id)
8. 93.573 93.573 ↑ 1.0 415,935 1

Seq Scan on venues (cost=0.00..15,475.35 rows=415,935 width=20) (actual time=0.009..93.573 rows=415,935 loops=1)

9. 39.472 70.059 ↑ 1.0 167,728 1

Hash (cost=3,123.28..3,123.28 rows=167,728 width=8) (actual time=70.059..70.059 rows=167,728 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2655kB
10. 30.587 30.587 ↑ 1.0 167,728 1

Seq Scan on venues_profiles (cost=0.00..3,123.28 rows=167,728 width=8) (actual time=0.006..30.587 rows=167,728 loops=1)