explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dxUoL

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 15.028 ↑ 1.0 100 1

Limit (cost=1,215.44..1,336.53 rows=100 width=1,624) (actual time=13.868..15.028 rows=100 loops=1)

2. 0.204 14.979 ↑ 16.5 1,100 1

Nested Loop (cost=4.52..21,998.34 rows=18,163 width=1,624) (actual time=0.131..14.979 rows=1,100 loops=1)

3. 2.620 12.355 ↑ 16.5 220 1

Hash Join (cost=4.09..17,574.48 rows=3,632 width=16) (actual time=0.119..12.355 rows=220 loops=1)

  • Hash Cond: ((sighting1_.marketplace_id)::text = (marketplac3_.id)::text)
4. 9.712 9.712 ↑ 15.2 25,867 1

Seq Scan on sightings sighting1_ (cost=0.00..16,501.32 rows=392,288 width=27) (actual time=0.010..9.712 rows=25,867 loops=1)

  • Filter: ((state)::text <> ALL ('{DROPEED,INITIAL,PROCESSING}'::text[]))
  • Rows Removed by Filter: 17,105
5. 0.002 0.023 ↑ 1.0 1 1

Hash (cost=4.08..4.08 rows=1 width=10) (actual time=0.022..0.023 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on marketplaces marketplac3_ (cost=0.00..4.08 rows=1 width=10) (actual time=0.020..0.021 rows=1 loops=1)

  • Filter: fetch_media_required
  • Rows Removed by Filter: 110
7. 2.420 2.420 ↑ 1.2 5 220

Index Scan using "IDXm2d6ajwdi1vxkx4fok67abjxj" on sightings_media sightingme0_ (cost=0.43..1.16 rows=6 width=1,624) (actual time=0.009..0.011 rows=5 loops=220)

  • Index Cond: (sighting_id = sighting1_.id)
  • Filter: ((original_url IS NULL) AND (fetch_attempts < 3))