explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qvI1

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 15.749 ↑ 1.0 20 1

Limit (cost=10,998.74..10,998.79 rows=20 width=10,916) (actual time=15.729..15.749 rows=20 loops=1)

2. 0.471 15.734 ↑ 23.8 20 1

Sort (cost=10,998.74..10,999.93 rows=475 width=10,916) (actual time=15.727..15.734 rows=20 loops=1)

  • Sort Key: n1_.created_dt
  • Sort Method: top-N heapsort Memory: 45kB
3. 0.407 15.263 ↑ 1.6 297 1

Nested Loop (cost=227.57..10,986.10 rows=475 width=10,916) (actual time=8.371..15.263 rows=297 loops=1)

4. 0.028 0.028 ↑ 1.0 1 1

Index Scan using gf_player_pkey on gf_player player7_ (cost=0.29..8.30 rows=1 width=3,395) (actual time=0.026..0.028 rows=1 loops=1)

  • Index Cond: (player_id = 17648)
5. 0.662 14.828 ↑ 1.6 297 1

Nested Loop Left Join (cost=227.28..10,973.04 rows=475 width=7,521) (actual time=8.340..14.828 rows=297 loops=1)

6. 0.584 13.572 ↑ 1.6 297 1

Nested Loop Left Join (cost=226.99..7,873.01 rows=475 width=4,126) (actual time=8.333..13.572 rows=297 loops=1)

7. 0.350 12.988 ↑ 1.6 297 1

Hash Left Join (cost=226.70..4,729.95 rows=475 width=731) (actual time=8.328..12.988 rows=297 loops=1)

  • Hash Cond: (n1_.icon = fileentry4_.id)
8. 0.708 7.697 ↑ 1.6 297 1

Nested Loop (cost=0.85..4,501.12 rows=475 width=296) (actual time=3.378..7.697 rows=297 loops=1)

9. 5.153 5.153 ↓ 1.3 612 1

Index Scan using be_player_notification_deleted_player_id_index on be_player_notification this_ (cost=0.43..857.24 rows=478 width=42) (actual time=0.036..5.153 rows=612 loops=1)

  • Index Cond: ((deleted = false) AND (player_id = 17648))
  • Filter: (NOT deleted)
10. 1.836 1.836 ↓ 0.0 0 612

Index Scan using be_notifications_pkey on be_notifications n1_ (cost=0.42..7.61 rows=1 width=254) (actual time=0.003..0.003 rows=0 loops=612)

  • Index Cond: (notification_id = this_.notification_id)
  • Filter: ((visible OR (visible IS NULL)) AND ((start_date IS NULL) OR (start_date <= '2020-03-25 15:12:28.067'::timestamp without time zone)) AND ((end_date IS NULL) OR (end_date >= '2020-03-25 15:12:28.067'::timestamp without time zone)) AND ((notification_channel)::text = 'NOTIFICATION'::text))
  • Rows Removed by Filter: 1
11. 2.127 4.941 ↑ 1.0 3,060 1

Hash (cost=187.60..187.60 rows=3,060 width=435) (actual time=4.941..4.941 rows=3,060 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1240kB
12. 2.814 2.814 ↑ 1.0 3,060 1

Seq Scan on gf_file_entry fileentry4_ (cost=0.00..187.60 rows=3,060 width=435) (actual time=0.010..2.814 rows=3,060 loops=1)

13. 0.000 0.000 ↓ 0.0 0 297

Index Scan using gf_player_pkey on gf_player player5_ (cost=0.29..6.61 rows=1 width=3,395) (actual time=0.000..0.000 rows=0 loops=297)

  • Index Cond: (fileentry4_.owner_id = player_id)
14. 0.594 0.594 ↑ 1.0 1 297

Index Scan using gf_player_pkey on gf_player player6_ (cost=0.29..6.52 rows=1 width=3,395) (actual time=0.002..0.002 rows=1 loops=297)

  • Index Cond: (n1_.owner_id = player_id)
Total runtime : 15.999 ms