explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mnjt

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 226,487.971 ↑ 1.3 3 1

Limit (cost=412.58..7,361.04 rows=4 width=16) (actual time=197,466.157..226,487.971 rows=3 loops=1)

2.          

Initplan (for Limit)

3. 0.210 23.374 ↑ 1.0 1 1

Bitmap Heap Scan on research_outputs (cost=408.00..412.01 rows=1 width=8) (actual time=23.373..23.374 rows=1 loops=1)

  • Recheck Cond: (document @@ '''migrat'' & ''amidst'' & ''climat'' & ''rigid'' & ''trap'''::tsquery)
  • Heap Blocks: exact=1
4. 23.164 23.164 ↑ 1.0 1 1

Bitmap Index Scan on research_outputs_3 (cost=0.00..408.00 rows=1 width=0) (actual time=23.164..23.164 rows=1 loops=1)

  • Index Cond: (document @@ '''migrat'' & ''amidst'' & ''climat'' & ''rigid'' & ''trap'''::tsquery)
5. 0.035 226,487.965 ↑ 2,261.7 3 1

Result (cost=0.57..11,786,320.16 rows=6,785 width=16) (actual time=197,466.154..226,487.965 rows=3 loops=1)

6. 0.041 226,487.930 ↑ 2,261.7 3 1

Unique (cost=0.57..11,786,320.16 rows=6,785 width=16) (actual time=197,466.133..226,487.930 rows=3 loops=1)

7. 226,487.889 226,487.889 ↑ 2,262.3 3 1

Index Scan using mentions_5 on mentions (cost=0.57..11,786,286.23 rows=6,787 width=16) (actual time=197,466.123..226,487.889 rows=3 loops=1)

  • Filter: (research_output_id = ANY ($0))
  • Rows Removed by Filter: 124974652
Planning time : 38.684 ms
Execution time : 226,488.131 ms