explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R3Wy

Settings
# exclusive inclusive rows x rows loops node
1. 36.768 391.089 ↓ 531.0 531 1

Nested Loop Left Join (cost=0.42..48,807.88 rows=1 width=24) (actual time=6.366..391.089 rows=531 loops=1)

  • Join Filter: (table0.subs_id = table3.subs_id)
  • Rows Removed by Join Filter: 188707
2. 64.935 341.046 ↓ 531.0 531 1

Nested Loop Left Join (cost=0.42..48,796.57 rows=1 width=20) (actual time=6.246..341.046 rows=531 loops=1)

  • Join Filter: (table0.subs_id = table2.subs_id)
  • Rows Removed by Join Filter: 356425
3. 0.319 244.782 ↓ 531.0 531 1

Nested Loop Left Join (cost=0.42..48,773.63 rows=1 width=12) (actual time=0.023..244.782 rows=531 loops=1)

4. 237.029 237.029 ↓ 531.0 531 1

Seq Scan on subscriber table0 (cost=0.00..48,765.18 rows=1 width=8) (actual time=0.012..237.029 rows=531 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: 883599
5. 7.434 7.434 ↑ 1.0 1 531

Index Scan using pst_subs_idx on prepaid_subs_topup table1 (cost=0.42..8.44 rows=1 width=10) (actual time=0.013..0.014 rows=1 loops=531)

  • Index Cond: (table0.subs_id = subs_id)
6. 31.329 31.329 ↓ 1.0 672 531

Seq Scan on prepaid_subs_usage table2 (cost=0.00..14.64 rows=664 width=16) (actual time=0.004..0.059 rows=672 loops=531)

7. 13.275 13.275 ↓ 1.1 356 531

Seq Scan on prepaid_subs_promo table3 (cost=0.00..7.25 rows=325 width=12) (actual time=0.002..0.025 rows=356 loops=531)

Planning time : 7.976 ms
Execution time : 391.216 ms