explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wHs2

Settings
# exclusive inclusive rows x rows loops node
1. 8,940.021 25,123.988 ↑ 1.0 1 1

Aggregate (cost=1,132,294.68..1,132,294.69 rows=1 width=8) (actual time=25,123.987..25,123.988 rows=1 loops=1)

2. 13,714.555 16,183.967 ↓ 1.1 73,271,194 1

Hash Join (cost=13.84..958,460.65 rows=69,533,612 width=8) (actual time=5.519..16,183.967 rows=73,271,194 loops=1)

  • Hash Cond: (p1_.id = e0_.bp_fk)
3. 1,323.909 2,469.283 ↓ 1.1 7,014,665 1

Nested Loop (cost=2.18..250,297.09 rows=6,613,827 width=12) (actual time=0.058..2,469.283 rows=7,014,665 loops=1)

4. 0.052 0.109 ↑ 1.0 33 1

Hash Join (cost=1.74..3.55 rows=33 width=8) (actual time=0.041..0.109 rows=33 loops=1)

  • Hash Cond: (p1_.id = e2_.bp_definition_fk)
5. 0.027 0.027 ↑ 1.0 35 1

Seq Scan on bp_definition p1_ (cost=0.00..1.35 rows=35 width=4) (actual time=0.005..0.027 rows=35 loops=1)

6. 0.023 0.030 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=4) (actual time=0.030..0.030 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 0.007 0.007 ↑ 1.0 33 1

Seq Scan on best_practice e2_ (cost=0.00..1.33 rows=33 width=4) (actual time=0.003..0.007 rows=33 loops=1)

8. 1,145.265 1,145.265 ↑ 1.0 212,566 33

Index Only Scan using meta_flight_bp_values_bp_definition_idx on meta_flight_bp_values e3_ (cost=0.43..5,392.57 rows=219,208 width=4) (actual time=0.013..34.705 rows=212,566 loops=33)

  • Index Cond: (bp_definition_fk = p1_.id)
  • Heap Fetches: 0
9. 0.042 0.129 ↑ 1.0 296 1

Hash (cost=7.96..7.96 rows=296 width=12) (actual time=0.129..0.129 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
10. 0.087 0.087 ↑ 1.0 296 1

Seq Scan on reference_marks e0_ (cost=0.00..7.96 rows=296 width=12) (actual time=0.013..0.087 rows=296 loops=1)