explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SvSG

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 7.114 ↑ 1.0 5 1

Limit (cost=4,439.09..4,661.01 rows=5 width=16) (actual time=5.840..7.114 rows=5 loops=1)

2. 0.070 7.107 ↑ 169.0 105 1

Nested Loop (cost=0.85..787,743.82 rows=17,749 width=16) (actual time=3.782..7.107 rows=105 loops=1)

3. 6.827 6.827 ↑ 505.9 105 1

Index Scan Backward using idx_updatedat_resellercatalogueactionsummary on resellercatalogueactionsummary (cost=0.44..723,302.07 rows=53,124 width=16) (actual time=3.767..6.827 rows=105 loops=1)

  • Filter: (storeid = 414789)
  • Rows Removed by Filter: 27582
4. 0.210 0.210 ↑ 1.0 1 105

Index Scan using wholesalecataloguetable_pkey on wholesalecataloguetable (cost=0.42..1.21 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=105)

  • Index Cond: (catalogueid = resellercatalogueactionsummary.catalogueid)
  • Filter: (cataloguestatus = 'visible'::text)
Planning time : 0.409 ms
Execution time : 7.134 ms