explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iekw

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 707.326 ↑ 1.0 5 1

Limit (cost=11,263.10..11,776.21 rows=5 width=16) (actual time=660.263..707.326 rows=5 loops=1)

2. 0.000 707.316 ↑ 57.5 105 1

Gather Merge (cost=1,000.88..621,044.09 rows=6,042 width=16) (actual time=246.807..707.316 rows=105 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.138 1,909.923 ↑ 66.3 38 3

Nested Loop (cost=0.85..619,346.67 rows=2,518 width=16) (actual time=239.547..636.641 rows=38 loops=3)

4. 1,905.624 1,905.624 ↑ 103.2 73 3

Parallel Index Scan Backward using idx_updatedat_resellercatalogueactionsummary on resellercatalogueactionsummary (cost=0.44..599,676.01 rows=7,535 width=16) (actual time=239.478..635.208 rows=73 loops=3)

  • Filter: (storeid = 657932)
  • Rows Removed by Filter: 1868955
5. 4.161 4.161 ↑ 1.0 1 219

Index Scan using wholesalecataloguetable_pkey on wholesalecataloguetable (cost=0.42..2.61 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=219)

  • Index Cond: (catalogueid = resellercatalogueactionsummary.catalogueid)
  • Filter: (cataloguestatus = 'visible'::text)
  • Rows Removed by Filter: 0