explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sf2b

Settings
# exclusive inclusive rows x rows loops node
1. 1,187.309 6,243.193 ↑ 1.1 248,731 1

Bitmap Heap Scan on funding_sources (cost=12,193.99..421,117.58 rows=271,512 width=522) (actual time=5,105.095..6,243.193 rows=248,731 loops=1)

  • Recheck Cond: (uuid IS NULL)
  • Filter: ("primary" AND (NOT is_deleted) AND (NOT unlinked))
  • Rows Removed by Filter: 55404
  • Heap Blocks: exact=194606
2. 5,055.884 5,055.884 ↑ 1.3 304,812 1

Bitmap Index Scan on index_funding_sources_on_uuid (cost=0.00..12,126.11 rows=385,807 width=0) (actual time=5,055.884..5,055.884 rows=304,812 loops=1)

  • Index Cond: (uuid IS NULL)
Planning time : 0.129 ms
Execution time : 6,298.822 ms