explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jGpfs

Settings
# exclusive inclusive rows x rows loops node
1. 3,191.536 3,849.760 ↓ 18.1 791,510 1

Bitmap Heap Scan on members (cost=23,343.25..136,131.25 rows=43,737 width=168) (actual time=722.551..3,849.760 rows=791,510 loops=1)

  • Recheck Cond: ((user_id IS NULL) AND (invite_token IS NOT NULL))
  • Filter: (created_at <= '2020-06-17 11:09:02.593574'::timestamp without time zone)
  • Rows Removed by Filter: 173,531
  • Heap Blocks: exact=201,043
  • Buffers: shared hit=91,783 read=123,009
  • I/O Timings: read=1,243.763
2. 10.207 658.224 ↓ 0.0 0 1

BitmapAnd (cost=23,343.25..23,343.25 rows=48,657 width=0) (actual time=658.224..658.224 rows=0 loops=1)

  • Buffers: shared hit=22 read=13,727
  • I/O Timings: read=282.298
3. 213.258 213.258 ↓ 1.0 965,638 1

Bitmap Index Scan on index_members_on_user_id (cost=0.00..11,310.73 rows=964,839 width=0) (actual time=213.257..213.258 rows=965,638 loops=1)

  • Index Cond: (user_id IS NULL)
  • Buffers: shared hit=3 read=2,744
  • I/O Timings: read=88.807
4. 434.759 434.759 ↓ 1.0 972,760 1

Bitmap Index Scan on index_members_on_invite_token (cost=0.00..12,010.40 rows=971,712 width=0) (actual time=434.759..434.759 rows=972,760 loops=1)

  • Index Cond: (invite_token IS NOT NULL)
  • Buffers: shared hit=19 read=10,983
  • I/O Timings: read=193.491
Planning time : 2.715 ms
Execution time : 3,899.114 ms