explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PkiB

Settings
# exclusive inclusive rows x rows loops node
1. 2,306.099 3,405.392 ↑ 1.0 7,014,666 1

Hash Right Join (cost=1.74..276,408.04 rows=7,062,960 width=4) (actual time=0.037..3,405.392 rows=7,014,666 loops=1)

  • Hash Cond: (e1_.best_practice_fk = e0_.id)
2. 1,099.270 1,099.270 ↑ 1.0 7,014,665 1

Seq Scan on meta_flight_bp_values e1_ (cost=0.00..179,290.60 rows=7,062,960 width=4) (actual time=0.005..1,099.270 rows=7,014,665 loops=1)

3. 0.006 0.023 ↑ 1.0 33 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 0.017 0.017 ↑ 1.0 33 1

Seq Scan on best_practice e0_ (cost=0.00..1.33 rows=33 width=4) (actual time=0.009..0.017 rows=33 loops=1)