explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cLmd

Settings
# exclusive inclusive rows x rows loops node
1. 0.231 4.689 ↓ 549.0 549 1

Nested Loop Left Join (cost=126.80..142.88 rows=1 width=24) (actual time=0.694..4.689 rows=549 loops=1)

2. 0.044 3.360 ↓ 549.0 549 1

Nested Loop Left Join (cost=126.53..134.57 rows=1 width=16) (actual time=0.682..3.360 rows=549 loops=1)

3. 0.299 1.120 ↓ 549.0 549 1

Merge Right Join (cost=126.10..126.12 rows=1 width=12) (actual time=0.664..1.120 rows=549 loops=1)

  • Merge Cond: (table3.subs_id = table0.subs_id)
4. 0.134 0.134 ↑ 1.0 356 1

Index Scan using psp_subs_idx on prepaid_subs_promo table3 (cost=0.27..41.37 rows=356 width=12) (actual time=0.036..0.134 rows=356 loops=1)

5. 0.362 0.687 ↓ 549.0 549 1

Sort (cost=119.70..119.70 rows=1 width=8) (actual time=0.621..0.687 rows=549 loops=1)

  • Sort Key: table0.subs_id
  • Sort Method: quicksort Memory: 50kB
6. 0.325 0.325 ↓ 549.0 549 1

Index Scan using subs_cfuid_idx on subscriber table0 (cost=0.42..119.69 rows=1 width=8) (actual time=0.023..0.325 rows=549 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. 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)
8. 1.098 1.098 ↑ 1.0 1 549

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

  • Index Cond: (table0.subs_id = subs_id)
Planning time : 7.800 ms
Execution time : 4.897 ms