explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iF04

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 15.956 ↑ 1.0 1 1

Limit (cost=1.27..72.33 rows=1 width=37) (actual time=15.950..15.956 rows=1 loops=1)

2. 0.476 15.949 ↑ 276.0 1 1

Nested Loop (cost=1.27..19,614.72 rows=276 width=37) (actual time=15.949..15.949 rows=1 loops=1)

  • Join Filter: (snapshot.id = nightly.snap)
  • Rows Removed by Join Filter: 1,893
3. 0.007 0.007 ↑ 1,568.0 1 1

Index Scan Backward using unique_nightly on nightly (cost=0.28..82.67 rows=1,568 width=12) (actual time=0.006..0.007 rows=1 loops=1)

4. 1.179 15.466 ↓ 7.0 1,894 1

Materialize (cost=0.99..13,182.33 rows=270 width=49) (actual time=0.037..15.466 rows=1,894 loops=1)

5. 1.904 14.287 ↓ 7.0 1,894 1

Nested Loop (cost=0.99..13,180.98 rows=270 width=49) (actual time=0.035..14.287 rows=1,894 loops=1)

6. 0.808 10.489 ↓ 4.7 1,894 1

Nested Loop (cost=0.72..13,062.06 rows=403 width=49) (actual time=0.030..10.489 rows=1,894 loops=1)

7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using unique_package_name on package_name (cost=0.29..8.30 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((name)::text = 'optparse-applicative'::text)
8. 1.628 9.666 ↓ 1.2 1,894 1

Nested Loop (cost=0.43..13,038.39 rows=1,537 width=57) (actual time=0.013..9.666 rows=1,894 loops=1)

9. 0.462 0.462 ↓ 1.2 1,894 1

Seq Scan on snapshot (cost=0.00..35.37 rows=1,537 width=25) (actual time=0.004..0.462 rows=1,894 loops=1)

10. 7.576 7.576 ↑ 1.0 1 1,894

Index Scan using unique_snapshot_package on snapshot_package (cost=0.43..8.45 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1,894)

  • Index Cond: ((snapshot = snapshot.id) AND (package_name = package_name.id))
11. 1.894 1.894 ↑ 1.0 1 1,894

Index Scan using version_pkey on version (cost=0.28..0.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,894)

  • Index Cond: (id = snapshot_package.version)
Planning time : 1.213 ms
Execution time : 16.039 ms