explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UH9J

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 12.079 ↓ 0.0 0 1

Limit (cost=40,113.97..40,114.29 rows=125 width=240) (actual time=12.079..12.079 rows=0 loops=1)

2. 0.007 12.078 ↓ 0.0 0 1

Sort (cost=40,113.97..40,114.29 rows=125 width=240) (actual time=12.078..12.078 rows=0 loops=1)

  • Sort Key: id DESC
  • Sort Method: quicksort Memory: 25kB
3. 10.080 12.071 ↓ 0.0 0 1

Bitmap Heap Scan on notification notificati0_ (cost=350.54..40,109.62 rows=125 width=240) (actual time=12.071..12.071 rows=0 loops=1)

  • Recheck Cond: (ugle_id = 17740)
  • Filter: ((NOT lu) AND (type_notification_id = 70))
  • Rows Removed by Filter: 18188
  • Heap Blocks: exact=7173
4. 1.991 1.991 ↓ 1.1 18,188 1

Bitmap Index Scan on notification_ugle_idx (cost=0.00..350.50 rows=15,876 width=0) (actual time=1.991..1.991 rows=18,188 loops=1)

  • Index Cond: (ugle_id = 17740)
Planning time : 0.125 ms
Execution time : 12.117 ms