explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YIOT

Settings
# exclusive inclusive rows x rows loops node
1. 42,724.807 81,172.607 ↓ 1.3 107,339,607 1

Hash Join (cost=988.48..5,402,490.13 rows=83,317,680 width=25) (actual time=391.797..81,172.607 rows=107,339,607 loops=1)

  • Hash Cond: ((products.seller_id)::text = (seller_marketplaces.seller_id)::text)
  • Functions: 23
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.040 ms, Inlining 10.060 ms, Optimization 241.857 ms, Emission 115.418 ms, Total 373.375 ms
2. 38,057.481 38,057.481 ↓ 1.0 83,936,382 1

Seq Scan on products (cost=0.00..4,163,598.57 rows=80,945,257 width=39) (actual time=0.279..38,057.481 rows=83,936,382 loops=1)

3. 2.592 390.319 ↓ 1.0 6,421 1

Hash (cost=909.13..909.13 rows=6,348 width=28) (actual time=390.316..390.319 rows=6,421 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 450kB
4. 4.925 387.727 ↓ 1.0 6,421 1

Hash Join (cost=196.99..909.13 rows=6,348 width=28) (actual time=370.179..387.727 rows=6,421 loops=1)

  • Hash Cond: ((seller_marketplaces.seller_id)::text = (mws_credentials.seller_id)::text)
5. 380.424 380.424 ↓ 1.0 17,448 1

Seq Scan on seller_marketplaces (cost=0.00..666.39 rows=17,416 width=14) (actual time=367.771..380.424 rows=17,448 loops=1)

  • Filter: ((marketplace_id)::text = ANY ('{A17E79C6D8DWNP,A21TJRUUN4KGV,ATVPDKIKX0DER,ARBP9OOSHTCHU,APJ6JRA9NG5V4,A1PA6795UKMFR9,A1RKKUPIHCS9HS,A2EUQ1WTGCTBG2,ABCDEFG,A2VIGQ35RCS4UG,A1VC38T7YXB528,A39IBJ37TRP1C6,A1AM78C64UM0Y8,A1F83G8C2ARO7P,A1805IZSGTT6HS,HALKEAD}'::text[]))
  • Rows Removed by Filter: 402
6. 0.886 2.378 ↑ 1.0 2,252 1

Hash (cost=168.68..168.68 rows=2,265 width=14) (actual time=2.377..2.378 rows=2,252 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 135kB
7. 1.492 1.492 ↑ 1.0 2,252 1

Seq Scan on mws_credentials (cost=0.00..168.68 rows=2,265 width=14) (actual time=0.021..1.492 rows=2,252 loops=1)

  • Filter: ((state)::text = 'Authorized'::text)
  • Rows Removed by Filter: 3,946
Planning time : 12.825 ms
Execution time : 88,022.854 ms