explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CNKU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,772.187 ↑ 3,001.5 4 1

Hash Left Join (cost=1.11..900.55 rows=12,006 width=171) (actual time=43.391..1,772.187 rows=4 loops=1)

  • Hash Cond: (inclusivec0_.fk_customer_tag = customerta1_.id)
  • Filter: ((inclusivec0_.fk_rate = 1,211,562,740) OR (SubPlan 1))
  • Rows Removed by Filter: 23,892
2. 5.661 5.661 ↑ 1.0 23,896 1

Seq Scan on inclusive_contingent inclusivec0_ (cost=0.00..836.42 rows=24,007 width=171) (actual time=0.004..5.661 rows=23,896 loops=1)

  • Filter: active
  • Rows Removed by Filter: 37
3. 0.004 0.007 ↓ 1.2 6 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.007..0.007 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.003 0.003 ↓ 1.2 6 1

Seq Scan on customer_tag customerta1_ (cost=0.00..1.05 rows=5 width=8) (actual time=0.002..0.003 rows=6 loops=1)

5.          

SubPlan (for Hash Left Join)

6. 1,768.008 1,768.008 ↓ 0.0 0 23,892

Seq Scan on customer_to_customer_tag customers2_ (cost=0.00..24.45 rows=263 width=8) (actual time=0.074..0.074 rows=0 loops=23,892)

  • Filter: (customerta1_.id = fk_customer_tag)
  • Rows Removed by Filter: 1,431
Planning time : 0.445 ms
Execution time : 1,772.227 ms