explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BubZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.308 2.280 ↓ 32.0 32 1

Nested Loop (cost=1.28..131.88 rows=1 width=2,275) (actual time=0.245..2.280 rows=32 loops=1)

2. 0.066 1.876 ↓ 32.0 32 1

Nested Loop (cost=1.14..123.61 rows=1 width=2,269) (actual time=0.222..1.876 rows=32 loops=1)

3. 0.253 1.714 ↓ 32.0 32 1

Nested Loop (cost=0.99..115.35 rows=1 width=2,055) (actual time=0.194..1.714 rows=32 loops=1)

  • Join Filter: (ft.mp_payee_payinstrument_dimid = pint.payinstrument_dimid)
  • Rows Removed by Join Filter: 640
4. 0.068 1.237 ↓ 32.0 32 1

Nested Loop (cost=0.99..112.79 rows=1 width=2,045) (actual time=0.177..1.237 rows=32 loops=1)

  • Join Filter: (ft.mp_payer_payinstrument_dimid = pin.payinstrument_dimid)
5. 0.096 0.881 ↓ 32.0 32 1

Nested Loop (cost=0.99..110.75 rows=1 width=2,035) (actual time=0.149..0.881 rows=32 loops=1)

6. 0.038 0.689 ↓ 32.0 32 1

Nested Loop (cost=0.71..102.44 rows=1 width=1,970) (actual time=0.136..0.689 rows=32 loops=1)

7. 0.062 0.555 ↓ 32.0 32 1

Nested Loop (cost=0.57..94.28 rows=1 width=1,796) (actual time=0.127..0.555 rows=32 loops=1)

8. 0.016 0.301 ↓ 32.0 32 1

Append (cost=0.29..85.97 rows=1 width=1,733) (actual time=0.107..0.301 rows=32 loops=1)

9. 0.285 0.285 ↓ 32.0 32 1

Index Scan using idx_servicetype_jun_2016 on fact_transaction_header_jun_2016 ft (cost=0.29..85.97 rows=1 width=1,733) (actual time=0.106..0.285 rows=32 loops=1)

  • Index Cond: ((servicetype)::text = 'MERCHPAY'::text)
  • Filter: ((transfer_date >= '2016-06-01 00:00:00'::timestamp without time zone) AND (transfer_date < '2016-06-30 00:00:00'::timestamp without time zone) AND (service_type_dimid = 21))
  • Rows Removed by Filter: 26
10. 0.192 0.192 ↑ 1.0 1 32

Index Scan using dim_user_pkey on dim_user u (cost=0.28..8.31 rows=1 width=71) (actual time=0.006..0.006 rows=1 loops=32)

  • Index Cond: (user_dimid = ft.payer_user_dimid)
  • Filter: ((partyacc_providerdimid = 101) AND ((user_type)::text = 'SUBSCRIBER'::text))
11. 0.096 0.096 ↑ 1.0 1 32

Index Scan using idx_providerid on dim_provider p (cost=0.14..8.16 rows=1 width=182) (actual time=0.002..0.003 rows=1 loops=32)

  • Index Cond: (provider_id = 101)
12. 0.096 0.096 ↑ 1.0 1 32

Index Scan using dim_user_pkey on dim_user ue (cost=0.28..8.30 rows=1 width=73) (actual time=0.003..0.003 rows=1 loops=32)

  • Index Cond: (user_dimid = ft.payee_user_dimid)
13. 0.288 0.288 ↑ 1.0 1 32

Seq Scan on dim_payinstrument pin (cost=0.00..2.04 rows=1 width=18) (actual time=0.009..0.009 rows=1 loops=32)

  • Filter: (((payment_instrument)::text = 'WALLET'::text) AND ((sub_payment_type_name)::text = 'Normal'::text))
  • Rows Removed by Filter: 20
14. 0.224 0.224 ↑ 3.3 21 32

Seq Scan on dim_payinstrument pint (cost=0.00..1.69 rows=69 width=18) (actual time=0.003..0.007 rows=21 loops=32)

15. 0.096 0.096 ↑ 1.0 1 32

Index Scan using dim_transtatus_pkey on dim_transtatus dt (cost=0.14..8.16 rows=1 width=222) (actual time=0.003..0.003 rows=1 loops=32)

  • Index Cond: (transtatus_dimid = ft.transtatus_dimid)
16. 0.096 0.096 ↑ 1.0 1 32

Index Scan using dim_servicetype_pkey on dim_servicetype st (cost=0.15..8.17 rows=1 width=28) (actual time=0.002..0.003 rows=1 loops=32)

  • Index Cond: (service_dimid = 21)
Planning time : 16.751 ms
Execution time : 2.695 ms