explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWZa

Settings
# exclusive inclusive rows x rows loops node
1. 0.365 7.839 ↓ 531.0 531 1

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

2. 0.411 4.819 ↓ 531.0 531 1

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

3. 0.470 1.222 ↓ 531.0 531 1

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

  • Merge Cond: (table3.subs_id = table0.subs_id)
4. 0.189 0.189 ↓ 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.024..0.189 rows=356 loops=1)

5. 0.276 0.563 ↓ 531.0 531 1

Sort (cost=119.70..119.70 rows=1 width=8) (actual time=0.486..0.563 rows=531 loops=1)

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

Index Scan using subscriber_cfuid_idx on subscriber table0 (cost=0.42..119.69 rows=1 width=8) (actual time=0.015..0.287 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. 3.186 3.186 ↑ 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.005..0.006 rows=1 loops=531)

  • Index Cond: (table0.subs_id = subs_id)
8. 2.655 2.655 ↑ 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.005..0.005 rows=1 loops=531)

  • Index Cond: (table0.subs_id = subs_id)
Planning time : 10.443 ms
Execution time : 7.993 ms