explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6nBc

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 3,226.599 ↑ 1.0 20 1

Limit (cost=8,771.03..8,771.08 rows=20 width=7,521) (actual time=3,226.576..3,226.599 rows=20 loops=1)

2. 10.112 3,226.576 ↑ 11.9 40 1

Sort (cost=8,770.98..8,772.17 rows=475 width=7,521) (actual time=3,226.560..3,226.576 rows=40 loops=1)

  • Sort Key: n1_.created_dt
  • Sort Method: top-N heapsort Memory: 65kB
3. 0.609 3,216.464 ↑ 1.6 297 1

Nested Loop (cost=240.18..8,755.97 rows=475 width=7,521) (actual time=3,074.415..3,216.464 rows=297 loops=1)

4. 0.757 0.757 ↑ 1.0 1 1

Index Scan using gf_player_pkey on gf_player player6_ (cost=0.29..8.30 rows=1 width=3,395) (actual time=0.756..0.757 rows=1 loops=1)

  • Index Cond: (player_id = 17648)
5. 0.936 3,215.098 ↑ 1.6 297 1

Nested Loop Left Join (cost=239.89..8,742.91 rows=475 width=4,126) (actual time=3,073.625..3,215.098 rows=297 loops=1)

6. 1.329 3,212.380 ↑ 1.6 297 1

Hash Left Join (cost=239.60..5,668.39 rows=475 width=731) (actual time=3,073.373..3,212.380 rows=297 loops=1)

  • Hash Cond: (n1_.icon = fileentry4_.id)
7. 2.440 3,144.077 ↑ 1.6 297 1

Nested Loop (cost=13.75..5,439.56 rows=475 width=296) (actual time=3,005.664..3,144.077 rows=297 loops=1)

8. 827.187 3,134.293 ↓ 1.3 612 1

Bitmap Heap Scan on be_player_notification this_ (cost=13.33..1,799.68 rows=478 width=42) (actual time=2,307.618..3,134.293 rows=612 loops=1)

  • Recheck Cond: (player_id = 17648)
  • Filter: (NOT deleted)
9. 2,307.106 2,307.106 ↓ 1.4 647 1

Bitmap Index Scan on be_player_notification_player_id_deleted_index (cost=0.00..13.21 rows=478 width=0) (actual time=2,307.106..2,307.106 rows=647 loops=1)

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

Index Scan using be_notifications_pkey on be_notifications n1_ (cost=0.42..7.60 rows=1 width=254) (actual time=0.012..0.012 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-26 01:19:42.604'::timestamp without time zone)) AND ((end_date IS NULL) OR (end_date >= '2020-03-26 01:19:42.604'::timestamp without time zone)) AND ((notification_channel)::text = 'NOTIFICATION'::text))
  • Rows Removed by Filter: 1
11. 63.348 66.974 ↑ 1.0 3,060 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1240kB
12. 3.626 3.626 ↑ 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.016..3.626 rows=3,060 loops=1)

13. 1.782 1.782 ↑ 1.0 1 297

Index Scan using gf_player_pkey on gf_player player5_ (cost=0.29..6.46 rows=1 width=3,395) (actual time=0.005..0.006 rows=1 loops=297)

  • Index Cond: (n1_.owner_id = player_id)
Total runtime : 3,229.551 ms