explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qe19

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 366.516 ↓ 0.0 0 1

GroupAggregate (cost=3,667.20..3,668.26 rows=53 width=36) (actual time=366.516..366.516 rows=0 loops=1)

  • Group Key: _sip.product_id
2.          

CTE _sip

3. 3.291 4.220 ↓ 1.2 78 1

Nested Loop (cost=1.13..853.08 rows=67 width=36) (actual time=0.065..4.220 rows=78 loops=1)

4. 0.464 0.464 ↑ 1.0 93 1

Index Scan using uniq_idx_search_index_products_on_product_id on search_index_products sip (cost=0.56..426.15 rows=93 width=360) (actual time=0.017..0.464 rows=93 loops=1)

  • Index Cond: (product_id = ANY ('{222799613,222799614,222799615,222799616,222799617,222799618,222799619,222799620,222799621,222799622,222799623,222799624,222799625,222799626,222799627,222799628,222799629,222799630,222799631,222799632,222799634,222799633,222799635,222799636,222799637,222799638,222799639,222799640,222799641,222799642,222799643,222799644,222799645,222799646,222799647,222799648,222799649,222799650,222799651,222799652,222799653,222799654,222799655,222799656,222799657,222799658,222799659,222799660,222799661,222799662,222799663,222799664,222799665,222799666,222799667,222799668,222799669,222799670,222799671,222799672,222799673,222799674,222799675,222799676,222799677,222799678,222799679,222799680,222799681,222799682,222799684,222799685,222799686,222799687,222799688,222799689,222799683,222799690,222799692,222799693,222799694,222799695,222799696,222799691,222799697,222799698,222799699,222799700,222799701,222799702,222799703,222799706,222799705}'::integer[]))
5. 0.465 0.465 ↑ 1.0 1 93

Index Scan using products_413_pkey on products p (cost=0.56..4.59 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=93)

  • Index Cond: (id = sip.product_id)
  • Filter: ((public_state <> 'deleted'::product_public_state) AND (state = ANY ('{pending,accepted,changed}'::product_state[])))
  • Rows Removed by Filter: 0
6. 0.009 366.515 ↓ 0.0 0 1

Sort (cost=2,814.12..2,814.26 rows=53 width=21) (actual time=366.515..366.515 rows=0 loops=1)

  • Sort Key: _sip.product_id
  • Sort Method: quicksort Memory: 25kB
7. 361.461 366.506 ↓ 0.0 0 1

Nested Loop (cost=0.00..2,812.61 rows=53 width=21) (actual time=366.506..366.506 rows=0 loops=1)

  • Join Filter: (to_tsvector('simple'::regconfig, _sip.ft) @@ sw.word_query)
  • Rows Removed by Join Filter: 12,324
8. 4.343 4.343 ↓ 1.2 78 1

CTE Scan on _sip (cost=0.00..1.34 rows=67 width=36) (actual time=0.067..4.343 rows=78 loops=1)

9. 0.667 0.702 ↑ 1.0 158 78

Materialize (cost=0.00..6.37 rows=158 width=89) (actual time=0.000..0.009 rows=158 loops=78)

10. 0.035 0.035 ↑ 1.0 158 1

Seq Scan on moderation_stop_words sw (cost=0.00..5.58 rows=158 width=89) (actual time=0.004..0.035 rows=158 loops=1)

Planning time : 0.442 ms
Execution time : 366.576 ms