explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OfD1

Settings
# exclusive inclusive rows x rows loops node
1. 36.396 377.912 ↓ 549.0 549 1

Nested Loop Left Join (cost=0.42..48,778.39 rows=1 width=24) (actual time=0.314..377.912 rows=549 loops=1)

  • Join Filter: (table0.subs_id = table3.subs_id)
  • Rows Removed by Join Filter: 195115
2. 65.110 328.340 ↓ 549.0 549 1

Nested Loop Left Join (cost=0.42..48,767.08 rows=1 width=20) (actual time=0.215..328.340 rows=549 loops=1)

  • Join Filter: (table0.subs_id = table2.subs_id)
  • Rows Removed by Join Filter: 368521
3. 0.460 237.976 ↓ 549.0 549 1

Nested Loop Left Join (cost=0.42..48,744.14 rows=1 width=12) (actual time=0.022..237.976 rows=549 loops=1)

4. 235.320 235.320 ↓ 549.0 549 1

Seq Scan on subscriber table0 (cost=0.00..48,735.69 rows=1 width=8) (actual time=0.011..235.320 rows=549 loops=1)

  • Filter: (cfu_id = ANY ('{4,5,8,10,27,106,107,108,109,110,111,112,114,115,116,117,119,124,129,132,134,136,147,177,178,179,187}'::integer[]))
  • Rows Removed by Filter: 883600
5. 2.196 2.196 ↑ 1.0 1 549

Index Scan using pst_subs_idx on prepaid_subs_topup table1 (cost=0.42..8.44 rows=1 width=10) (actual time=0.003..0.004 rows=1 loops=549)

  • Index Cond: (table0.subs_id = subs_id)
6. 25.254 25.254 ↓ 1.0 672 549

Seq Scan on prepaid_subs_usage table2 (cost=0.00..14.64 rows=664 width=16) (actual time=0.001..0.046 rows=672 loops=549)

7. 13.176 13.176 ↓ 1.1 356 549

Seq Scan on prepaid_subs_promo table3 (cost=0.00..7.25 rows=325 width=12) (actual time=0.001..0.024 rows=356 loops=549)

Planning time : 1.210 ms
Execution time : 378.013 ms