explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kj6Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 13.419 ↑ 1.0 10 1

Limit (cost=20,591.16..20,592.33 rows=10 width=16) (actual time=13.369..13.419 rows=10 loops=1)

2. 0.229 13.414 ↑ 156.0 10 1

Gather Merge (cost=20,591.16..20,773.18 rows=1,560 width=16) (actual time=13.368..13.414 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.261 13.185 ↑ 260.0 3 3

Sort (cost=19,591.14..19,593.09 rows=780 width=16) (actual time=4.395..4.395 rows=3 loops=3)

  • Sort Key: resellersharedcatalogsummarytable.time_stamp DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 1.800 12.924 ↑ 2.1 371 3

Nested Loop (cost=0.85..19,574.29 rows=780 width=16) (actual time=0.023..4.308 rows=371 loops=3)

5. 0.298 3.084 ↑ 1.7 1,340 3

Parallel Append (cost=0.44..10,686.39 rows=2,338 width=16) (actual time=0.009..1.028 rows=1,340 loops=3)

6. 2.778 2.778 ↑ 1.4 4,020 1

Index Scan using idx_storeid_resellersharedcatalogsummarytable on resellersharedcatalogsummarytable (cost=0.44..10,618.67 rows=5,603 width=16) (actual time=0.018..2.778 rows=4,020 loops=1)

  • Index Cond: (storeid = 125482)
7. 0.000 0.008 ↓ 0.0 0 1

GroupAggregate (cost=14.45..14.57 rows=7 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: downloadedcataloguesummary.catalogueid
8. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=14.45..14.47 rows=7 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: downloadedcataloguesummary.catalogueid
  • Sort Method: quicksort Memory: 25kB
9. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on downloadedcataloguesummary (cost=4.21..14.35 rows=7 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (storeid = 125482)
10. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on idx_storeid_downloadedcataloguesummary (cost=0.00..4.21 rows=7 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (storeid = 125482)
11. 8.040 8.040 ↓ 0.0 0 4,020

Index Scan using wholesalecataloguetable_pkey on wholesalecataloguetable (cost=0.42..3.80 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,020)

  • Index Cond: (catalogueid = resellersharedcatalogsummarytable.catalogueid)
  • Filter: (cataloguestatus = 'visible'::text)
  • Rows Removed by Filter: 1
Planning time : 0.207 ms
Execution time : 13.458 ms