explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qevd

Settings
# exclusive inclusive rows x rows loops node
1. 940.423 1,636.000 ↑ 1.0 2,236,319 1

Hash Join (cost=6,875.33..61,522.15 rows=2,258,904 width=4) (actual time=55.784..1,636.000 rows=2,236,319 loops=1)

  • Hash Cond: (wfelt.entity_id = bin.id)
2. 639.916 639.916 ↑ 1.0 2,236,319 1

Index Only Scan using idx_work_flow_entity_lead_time_entity on work_flow_entity_lead_time wfelt (cost=0.43..48,717.35 rows=2,258,904 width=4) (actual time=0.016..639.916 rows=2,236,319 loops=1)

  • Index Cond: (entity_type_id = 67)
  • Heap Fetches: 0
3. 25.526 55.661 ↑ 1.0 90,751 1

Hash (cost=5,740.51..5,740.51 rows=90,751 width=4) (actual time=55.661..55.661 rows=90,751 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4215kB
4. 30.135 30.135 ↑ 1.0 90,751 1

Seq Scan on base_invoice bin (cost=0.00..5,740.51 rows=90,751 width=4) (actual time=0.006..30.135 rows=90,751 loops=1)