explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LrMU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.097 9,233.311 ↑ 1.0 100 1

Nested Loop (cost=902,532.26..903,379.08 rows=100 width=118) (actual time=9,231.132..9,233.311 rows=100 loops=1)

2. 0.009 9,231.114 ↑ 1.0 100 1

Limit (cost=902,531.83..902,532.08 rows=100 width=799) (actual time=9,231.082..9,231.114 rows=100 loops=1)

3. 1,199.233 9,231.105 ↑ 61,220.7 100 1

Sort (cost=902,531.83..917,837.01 rows=6,122,074 width=799) (actual time=9,231.081..9,231.105 rows=100 loops=1)

  • Sort Key: materialized_view_flattened_judgements.probability DESC
  • Sort Method: top-N heapsort Memory: 32kB
4. 7,153.328 8,031.872 ↑ 1.0 6,054,111 1

Bitmap Heap Scan on materialized_view_flattened_judgements (cost=155,310.64..668,550.56 rows=6,122,074 width=799) (actual time=892.228..8,031.872 rows=6,054,111 loops=1)

  • Recheck Cond: ((label)::text = 'IDENTITY_ATTACK'::text)
  • Rows Removed by Index Recheck: 16451558
  • Heap Blocks: exact=41850 lossy=394864
5. 878.544 878.544 ↑ 1.0 6,054,111 1

Bitmap Index Scan on judgements_label_index (cost=0.00..153,780.12 rows=6,122,074 width=0) (actual time=878.544..878.544 rows=6,054,111 loops=1)

  • Index Cond: ((label)::text = 'IDENTITY_ATTACK'::text)
6. 2.100 2.100 ↑ 1.0 1 100

Index Scan using examples_pkey on examples e (cost=0.43..8.45 rows=1 width=95) (actual time=0.021..0.021 rows=1 loops=100)

  • Index Cond: (uuid = materialized_view_flattened_judgements.examples_uuid)
Planning time : 0.350 ms
Execution time : 9,233.453 ms