explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KDwW

Settings
# exclusive inclusive rows x rows loops node
1. 7.253 20.617 ↓ 296.0 296 1

Nested Loop (cost=2.29..150.08 rows=1 width=2,781) (actual time=0.194..20.617 rows=296 loops=1)

  • Join Filter: ((ft.payee_payment_type_id)::text = ((pint.payment_type_id)::character varying(20))::text)
  • Rows Removed by Join Filter: 10360
2. 0.635 8.628 ↓ 296.0 296 1

Nested Loop Left Join (cost=2.29..147.90 rows=1 width=1,787) (actual time=0.157..8.628 rows=296 loops=1)

3. 0.572 7.993 ↓ 296.0 296 1

Nested Loop Left Join (cost=2.14..146.49 rows=1 width=1,753) (actual time=0.152..7.993 rows=296 loops=1)

4. 0.751 6.533 ↓ 296.0 296 1

Nested Loop Left Join (cost=1.99..145.34 rows=1 width=1,727) (actual time=0.141..6.533 rows=296 loops=1)

5. 0.405 5.190 ↓ 296.0 296 1

Nested Loop Left Join (cost=1.85..143.92 rows=1 width=1,512) (actual time=0.132..5.190 rows=296 loops=1)

6. 0.166 4.193 ↓ 74.0 74 1

Nested Loop Left Join (cost=1.42..135.47 rows=1 width=1,497) (actual time=0.120..4.193 rows=74 loops=1)

7. 0.171 3.287 ↓ 74.0 74 1

Nested Loop Left Join (cost=0.99..127.01 rows=1 width=1,495) (actual time=0.106..3.287 rows=74 loops=1)

8. 0.172 2.302 ↓ 74.0 74 1

Nested Loop (cost=0.57..118.56 rows=1 width=1,448) (actual time=0.090..2.302 rows=74 loops=1)

9. 0.189 1.982 ↓ 74.0 74 1

Nested Loop (cost=0.43..110.39 rows=1 width=1,274) (actual time=0.083..1.982 rows=74 loops=1)

10. 0.114 0.831 ↓ 74.0 74 1

Nested Loop (cost=0.00..101.93 rows=1 width=1,229) (actual time=0.041..0.831 rows=74 loops=1)

  • Join Filter: ((ft.payer_payment_type_id)::text = ((pin.payment_type_id)::character varying(20))::text)
11. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on dim_payinstrument pin (cost=0.00..1.54 rows=1 width=182) (actual time=0.013..0.015 rows=1 loops=1)

  • Filter: (((payment_instrument)::text = 'WALLET'::text) AND ((sub_payment_type_name)::text = 'Normal'::text))
  • Rows Removed by Filter: 35
12. 0.071 0.702 ↑ 1.0 74 1

Append (cost=0.00..98.91 rows=74 width=1,051) (actual time=0.019..0.702 rows=74 loops=1)

13. 0.066 0.066 ↑ 1.0 8 1

Seq Scan on fact_transaction_header_jan_03_2019_000 ft (cost=0.00..9.02 rows=8 width=1,067) (actual time=0.018..0.066 rows=8 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 93
14. 0.080 0.080 ↑ 1.0 10 1

Seq Scan on fact_transaction_header_jan_03_2019_001 ft_1 (cost=0.00..11.56 rows=10 width=1,066) (actual time=0.019..0.080 rows=10 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 118
15. 0.011 0.020 ↑ 1.0 2 1

Bitmap Heap Scan on fact_transaction_header_jan_03_2019_002 ft_2 (cost=4.16..9.20 rows=2 width=1,028) (actual time=0.016..0.020 rows=2 loops=1)

  • Recheck Cond: ((servicetype)::text = 'MERCHPAY'::text)
  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Heap Blocks: exact=2
16. 0.009 0.009 ↑ 1.0 2 1

Bitmap Index Scan on idx_servicetype_jan_03_2019_002 (cost=0.00..4.16 rows=2 width=0) (actual time=0.008..0.009 rows=2 loops=1)

  • Index Cond: ((servicetype)::text = 'MERCHPAY'::text)
17. 0.076 0.076 ↑ 1.0 12 1

Seq Scan on fact_transaction_header_jan_03_2019_003 ft_3 (cost=0.00..10.32 rows=12 width=1,027) (actual time=0.016..0.076 rows=12 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 104
18. 0.079 0.079 ↑ 1.0 11 1

Seq Scan on fact_transaction_header_jan_03_2019_004 ft_4 (cost=0.00..11.68 rows=11 width=1,066) (actual time=0.023..0.079 rows=11 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 123
19. 0.061 0.061 ↑ 1.0 8 1

Seq Scan on fact_transaction_header_jan_03_2019_005 ft_5 (cost=0.00..9.02 rows=8 width=1,065) (actual time=0.020..0.061 rows=8 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 93
20. 0.067 0.067 ↑ 1.0 9 1

Seq Scan on fact_transaction_header_jan_03_2019_006 ft_6 (cost=0.00..10.48 rows=9 width=1,028) (actual time=0.014..0.067 rows=9 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 115
21. 0.062 0.062 ↑ 1.0 2 1

Seq Scan on fact_transaction_header_jan_03_2019_007 ft_7 (cost=0.00..9.08 rows=2 width=1,066) (actual time=0.050..0.062 rows=2 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 102
22. 0.055 0.055 ↑ 1.0 6 1

Seq Scan on fact_transaction_header_jan_03_2019_008 ft_8 (cost=0.00..9.12 rows=6 width=1,028) (actual time=0.015..0.055 rows=6 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 100
23. 0.065 0.065 ↑ 1.0 6 1

Seq Scan on fact_transaction_header_jan_03_2019_009 ft_9 (cost=0.00..9.06 rows=6 width=1,065) (actual time=0.020..0.065 rows=6 loops=1)

  • Filter: ((transfer_date >= '2019-01-03 00:00:00'::timestamp without time zone) AND (transfer_date < '2019-01-04 00:00:00'::timestamp without time zone) AND ((transfer_status)::text = 'TS': (...)
  • Rows Removed by Filter: 97
24. 0.962 0.962 ↑ 1.0 1 74

Index Scan using idx_dim_user_user_id on dim_user u (cost=0.43..8.45 rows=1 width=86) (actual time=0.013..0.013 rows=1 loops=74)

  • Index Cond: ((user_id)::text = (ft.payer_user_id)::text)
  • Filter: ((partyacc_providerdimid = 101) AND ((user_type)::text = 'SUBSCRIBER'::text))
25. 0.148 0.148 ↑ 1.0 1 74

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

  • Index Cond: (provider_id = 101)
26. 0.814 0.814 ↑ 1.0 1 74

Index Scan using idx_dim_user_user_id on dim_user ue (cost=0.43..8.45 rows=1 width=68) (actual time=0.010..0.011 rows=1 loops=74)

  • Index Cond: ((ft.payee_user_id)::text = (user_id)::text)
27. 0.740 0.740 ↑ 1.0 1 74

Index Scan using idx_dim_user_user_id on dim_user scp (cost=0.43..8.45 rows=1 width=40) (actual time=0.009..0.010 rows=1 loops=74)

  • Index Cond: ((ft.scp_partyid)::text = (user_id)::text)
28. 0.592 0.592 ↓ 4.0 4 74

Index Scan using idx_dim_user_user_id on dim_user scpe (cost=0.43..8.45 rows=1 width=40) (actual time=0.005..0.008 rows=4 loops=74)

  • Index Cond: ((ft.scp_secpartyid)::text = (user_id)::text)
29. 0.592 0.592 ↑ 1.0 1 296

Index Scan using idx_trans_status on dim_transtatus dt (cost=0.14..1.41 rows=1 width=316) (actual time=0.002..0.002 rows=1 loops=296)

  • Index Cond: (((ft.transfer_status)::text = (tran_status_id)::text) AND ((tran_status_id)::text = 'TS'::text))
30. 0.888 0.888 ↑ 1.0 1 296

Index Scan using idx_service_type on dim_servicetype st (cost=0.15..1.14 rows=1 width=34) (actual time=0.002..0.003 rows=1 loops=296)

  • Index Cond: (((ft.servicetype)::text = (service_type)::text) AND ((service_type)::text = 'MERCHPAY'::text))
31. 0.000 0.000 ↓ 0.0 0 296

Index Scan using idx_bank_id on dim_bank bnk (cost=0.14..1.41 rows=1 width=136) (actual time=0.000..0.000 rows=0 loops=296)

  • Index Cond: ((ft.bank_id)::text = (bank_id)::text)
32. 4.736 4.736 ↑ 1.0 36 296

Seq Scan on dim_payinstrument pint (cost=0.00..1.36 rows=36 width=182) (actual time=0.001..0.016 rows=36 loops=296)