explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QCg

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 165.684 4051.468 ↓ 3944.0 3944 1

Sort (cost=16.66..16.67 rows=1 width=445) (actual time=4045.665..4051.468 rows=3944 loops=1)

  • Sort Key: pdsll.game_point_id, pdsll.session_id, pdsll.device_id, pdsl.log_date, pdsll.meter_id, pdsll.currency_id, pdsll.denomination_value_cg, pdsll.game_id
2. 1167.490 3885.784 ↓ 3944.0 3944 1

Nested Loop (cost=1.03..16.65 rows=1 width=445) (actual time=0.519..3885.784 rows=3944 loops=1)

  • Join Filter: (("outer".device_id = "inner".device_id) AND ("outer".log_date = "inner".log_date))
3. 96.491 856.726 ↓ 3944.0 3944 1

Nested Loop (cost=1.03..10.65 rows=1 width=244) (actual time=0.469..856.726 rows=3944 loops=1)

  • Join Filter: ("outer".meter_id = "inner".meter_id)
4. 21.684 685.299 ↓ 3944.0 3944 1

Nested Loop (cost=1.03..9.23 rows=1 width=229) (actual time=0.456..685.299 rows=3944 loops=1)

  • Join Filter: ("outer".currency_id = "inner".currency_id)
5. 177.238 651.783 ↓ 3944.0 3944 1

Nested Loop (cost=1.03..8.18 rows=1 width=236) (actual time=0.443..651.783 rows=3944 loops=1)

  • Join Filter: (("inner".currency_id = "outer".currency_id) AND ("inner".currency_date = "outer".currency_date))
6. 22.150 312.841 ↓ 3944.0 3944 1

Nested Loop (cost=1.03..7.13 rows=1 width=221) (actual time=0.388..312.841 rows=3944 loops=1)

  • Join Filter: ("inner".currency_id = "outer".currency_id)
7. 14.611 14.611 ↓ 3944.0 3944 1

Index Scan using prm_device_session_lines_log_pkey on prm_device_session_line_log pdsll (cost=0.00..6.02 rows=1 width=203) (actual time=0.135..14.611 rows=3944 loops=1)

  • Index Cond: ((game_point_id = 2000::numeric) AND (session_id = 2::numeric) AND (game_id = 0::numeric))
8. 201.144 276.080 ↑ 1.0 2 3944

GroupAggregate (cost=1.03..1.07 rows=2 width=18) (actual time=0.032..0.070 rows=2 loops=3944)

9. 74.886 74.936 ↓ 16.5 33 3944

Sort (cost=1.03..1.03 rows=2 width=18) (actual time=0.001..0.019 rows=33 loops=3944)

  • Sort Key: public.scm_currency_cguitas.currency_id
10. 0.050 0.050 ↓ 16.5 33 1

Seq Scan on scm_currency_cguitas (cost=0.00..1.02 rows=2 width=18) (actual time=0.007..0.050 rows=33 loops=1)

11. 161.704 161.704 ↓ 16.5 33 3944

Seq Scan on scm_currency_cguitas (cost=0.00..1.02 rows=2 width=31) (actual time=0.002..0.041 rows=33 loops=3944)

12. 11.832 11.832 ↑ 1.0 2 3944

Seq Scan on scm_currencies sc (cost=0.00..1.02 rows=2 width=23) (actual time=0.001..0.003 rows=2 loops=3944)

13. 74.936 74.936 ↑ 1.0 19 3944

Seq Scan on acm_meters am (cost=0.00..1.19 rows=19 width=24) (actual time=0.002..0.019 rows=19 loops=3944)

14. 1861.568 1861.568 ↓ 232.0 232 3944

Index Scan using prm_device_sessions_log_pkey on prm_device_session_log pdsl (cost=0.00..5.98 rows=1 width=248) (actual time=0.015..0.472 rows=232 loops=3944)

  • Index Cond: ((2000::numeric = game_point_id) AND (2::numeric = session_id))