explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L4pf

Settings
# exclusive inclusive rows x rows loops node
1. 12.541 62,035.497 ↓ 47.4 83,649 1

Limit (cost=8,510.18..8,514.59 rows=1,765 width=95) (actual time=62,017.966..62,035.497 rows=83,649 loops=1)

2. 90.557 62,022.956 ↓ 47.4 83,649 1

Sort (cost=8,510.18..8,514.59 rows=1,765 width=95) (actual time=62,017.964..62,022.956 rows=83,649 loops=1)

  • Sort Key: "updateTime" DESC
  • Sort Method: quicksort Memory: 14836kB
3. 61,688.524 61,932.399 ↓ 47.4 83,649 1

Bitmap Heap Scan on "Tag" (cost=112.77..8,370.87 rows=1,765 width=95) (actual time=12,666.900..61,932.399 rows=83,649 loops=1)

  • Recheck Cond: (("updateTime" >= '1562130248865'::bigint) AND ("updateTime" < '1562130250865'::bigint))
  • Rows Removed by Index Recheck: 123689158
  • Heap Blocks: lossy=1918238
4. 243.875 243.875 ↓ 2,320.8 19,183,360 1

Bitmap Index Scan on "updTimeIndexBrin" (cost=0.00..112.33 rows=8,266 width=0) (actual time=243.875..243.875 rows=19,183,360 loops=1)

  • Index Cond: (("updateTime" >= '1562130248865'::bigint) AND ("updateTime" < '1562130250865'::bigint))
Planning time : 0.237 ms