explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EfxY

Settings
# exclusive inclusive rows x rows loops node
1. 673.750 3,354.073 ↓ 1.2 2,308,477 1

Hash Join (cost=18,414.66..268,964.42 rows=1,944,426 width=4) (actual time=127.675..3,354.073 rows=2,308,477 loops=1)

  • Hash Cond: (e1_.best_practice_fk = e0_.id)
2. 1,518.222 2,680.232 ↓ 1.2 2,308,477 1

Hash Join (cost=18,407.10..242,221.00 rows=1,944,426 width=4) (actual time=127.579..2,680.232 rows=2,308,477 loops=1)

  • Hash Cond: (e1_.meta_flight_fk = e5_.id)
3. 1,034.842 1,034.842 ↑ 1.0 7,014,665 1

Seq Scan on meta_flight_bp_values e1_ (cost=0.00..178,064.65 rows=7,014,665 width=8) (actual time=0.004..1,034.842 rows=7,014,665 loops=1)

4. 25.450 127.168 ↓ 1.0 139,787 1

Hash (cost=16,670.01..16,670.01 rows=138,967 width=4) (actual time=127.168..127.168 rows=139,787 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 6963kB
5. 101.718 101.718 ↓ 1.0 139,787 1

Seq Scan on meta_flight e5_ (cost=0.00..16,670.01 rows=138,967 width=4) (actual time=0.019..101.718 rows=139,787 loops=1)

  • Filter: ((dep_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2020-01-21 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Filter: 361547
6. 0.005 0.091 ↑ 1.0 33 1

Hash (cost=7.15..7.15 rows=33 width=4) (actual time=0.091..0.091 rows=33 loops=1)

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

Hash Join (cost=4.69..7.15 rows=33 width=4) (actual time=0.052..0.086 rows=33 loops=1)

  • Hash Cond: (b4_.domain_fk = p3_.id)
8. 0.013 0.064 ↑ 1.0 33 1

Hash Join (cost=3.53..5.79 rows=33 width=8) (actual time=0.039..0.064 rows=33 loops=1)

  • Hash Cond: (e0_.bp_definition_fk = b4_.bp_fk)
9. 0.018 0.037 ↑ 1.0 33 1

Hash Join (cost=1.74..3.55 rows=33 width=12) (actual time=0.021..0.037 rows=33 loops=1)

  • Hash Cond: (p2_.id = e0_.bp_definition_fk)
10. 0.006 0.006 ↑ 1.0 35 1

Seq Scan on bp_definition p2_ (cost=0.00..1.35 rows=35 width=4) (actual time=0.003..0.006 rows=35 loops=1)

11. 0.004 0.013 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=8) (actual time=0.013..0.013 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.009 0.009 ↑ 1.0 33 1

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

13. 0.005 0.014 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=8) (actual time=0.014..0.014 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.009 0.009 ↑ 1.0 35 1

Seq Scan on bp_domain_link b4_ (cost=0.00..1.35 rows=35 width=8) (actual time=0.003..0.009 rows=35 loops=1)

15. 0.003 0.009 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.009..0.009 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on domain p3_ (cost=0.00..1.07 rows=7 width=4) (actual time=0.005..0.006 rows=7 loops=1)