explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jv5R

Settings
# exclusive inclusive rows x rows loops node
1. 0.361 10,555.884 ↑ 1.0 100 1

Nested Loop (cost=893,443.75..894,290.57 rows=100 width=118) (actual time=10,378.387..10,555.884 rows=100 loops=1)

2. 0.031 10,371.023 ↑ 1.0 100 1

Limit (cost=893,443.32..893,443.57 rows=100 width=799) (actual time=10,370.886..10,371.023 rows=100 loops=1)

3. 1,220.372 10,370.992 ↑ 60,026.2 100 1

Sort (cost=893,443.32..908,449.87 rows=6,002,618 width=799) (actual time=10,370.885..10,370.992 rows=100 loops=1)

  • Sort Key: materialized_view_flattened_judgements.probability DESC
  • Sort Method: top-N heapsort Memory: 32kB
4. 7,464.436 9,150.620 ↓ 1.0 6,054,111 1

Bitmap Heap Scan on materialized_view_flattened_judgements (cost=152,280.85..664,027.58 rows=6,002,618 width=799) (actual time=1,699.264..9,150.620 rows=6,054,111 loops=1)

  • Recheck Cond: ((label)::text = 'SEXUAL_AGGRESSION'::text)
  • Rows Removed by Index Recheck: 16451494
  • Heap Blocks: exact=41850 lossy=394864
5. 1,686.184 1,686.184 ↓ 1.0 6,054,111 1

Bitmap Index Scan on judgements_label_index (cost=0.00..150,780.20 rows=6,002,618 width=0) (actual time=1,686.184..1,686.184 rows=6,054,111 loops=1)

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

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

  • Index Cond: (uuid = materialized_view_flattened_judgements.examples_uuid)
Planning time : 0.407 ms
Execution time : 10,555.969 ms