explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bma9

Settings
# exclusive inclusive rows x rows loops node
1. 0.435 14.213 ↓ 531.0 531 1

Nested Loop Left Join (cost=126.66..142.74 rows=1 width=24) (actual time=7.813..14.213 rows=531 loops=1)

2. 0.480 7.937 ↓ 531.0 531 1

Nested Loop Left Join (cost=126.39..134.43 rows=1 width=16) (actual time=5.431..7.937 rows=531 loops=1)

3. 0.290 5.864 ↓ 531.0 531 1

Merge Right Join (cost=125.96..125.98 rows=1 width=12) (actual time=5.422..5.864 rows=531 loops=1)

  • Merge Cond: (table3.subs_id = table0.subs_id)
4. 0.112 0.112 ↓ 1.1 356 1

Index Scan using psp_subs_idx on prepaid_subs_promo table3 (cost=0.27..40.91 rows=325 width=12) (actual time=0.016..0.112 rows=356 loops=1)

5. 0.230 5.462 ↓ 531.0 531 1

Sort (cost=119.70..119.70 rows=1 width=8) (actual time=5.401..5.462 rows=531 loops=1)

  • Sort Key: table0.subs_id
  • Sort Method: quicksort Memory: 49kB
6. 5.232 5.232 ↓ 531.0 531 1

Index Scan using subscriber_cfuid_idx on subscriber table0 (cost=0.42..119.69 rows=1 width=8) (actual time=3.858..5.232 rows=531 loops=1)

  • Index Cond: (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[]))
7. 1.593 1.593 ↑ 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.003..0.003 rows=1 loops=531)

  • Index Cond: (table0.subs_id = subs_id)
8. 5.841 5.841 ↑ 1.0 1 531

Index Scan using psu_subs_idx on prepaid_subs_usage table2 (cost=0.28..8.29 rows=1 width=16) (actual time=0.009..0.011 rows=1 loops=531)

  • Index Cond: (table0.subs_id = subs_id)
Planning time : 4.564 ms
Execution time : 14.314 ms