explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6B6O

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

Limit (cost=3,686.04..3,870.30 rows=5 width=16) (actual time=5.554..6.760 rows=5 loops=1)

2. 0.087 6.753 ↑ 205.3 105 1

Nested Loop (cost=0.85..794,453.49 rows=21,558 width=16) (actual time=3.594..6.753 rows=105 loops=1)

3. 6.456 6.456 ↑ 619.0 105 1

Index Scan Backward using idx_updatedat_resellercatalogueactionsummary on resellercatalogueactionsummary (cost=0.44..724,820.14 rows=64,992 width=16) (actual time=3.580..6.456 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.07 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.317 ms
Execution time : 6.781 ms