explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZHfB : Optimization for: plan #US23

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.066 ↑ 1.0 4 1

Limit (cost=1.00..46.93 rows=4 width=16) (actual time=0.037..0.066 rows=4 loops=1)

2. 0.006 0.064 ↑ 1,691,384.8 4 1

Unique (cost=1.00..77,675,208.25 rows=6,765,539 width=16) (actual time=0.036..0.064 rows=4 loops=1)

3. 0.007 0.058 ↑ 1,691,384.8 4 1

Nested Loop (cost=1.00..77,641,380.56 rows=6,765,539 width=16) (actual time=0.035..0.058 rows=4 loops=1)

4. 0.023 0.023 ↑ 29,802,386.0 4 1

Index Scan using mentions_5 on mentions (cost=0.57..9,747,054.70 rows=119,209,544 width=24) (actual time=0.016..0.023 rows=4 loops=1)

5. 0.028 0.028 ↑ 1.0 1 4

Index Scan using research_outputs_constraint_0 on research_outputs ro (cost=0.44..0.57 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=4)

  • Index Cond: (id = mentions.research_output_id)
  • Filter: (output_type = 'book'::text)
Planning time : 1.027 ms
Execution time : 0.112 ms