explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zEou

Settings
# exclusive inclusive rows x rows loops node
1. 48.656 238.431 ↑ 1.5 40,031 1

Gather (cost=1,109.59..62,760.85 rows=59,199 width=60) (actual time=2.539..238.431 rows=40,031 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 3.318 189.775 ↑ 1.8 8,006 5 / 5

Hash Join (cost=109.59..55,840.95 rows=14,800 width=60) (actual time=1.766..189.775 rows=8,006 loops=5)

  • Hash Cond: ("a"."channel_id" = "c"."id")
3. 3.532 185.166 ↑ 1.8 8,006 5 / 5

Nested Loop Anti Join (cost=1.11..55,693.53 rows=14,800 width=41) (actual time=0.343..185.166 rows=8,006 loops=5)

4. 5.559 148.456 ↑ 2.0 8,295 5 / 5

Nested Loop Anti Join (cost=0.55..45,816.19 rows=16,418 width=41) (actual time=0.200..148.456 rows=8,295 loops=5)

5. 56.357 56.357 ↑ 1.3 14,423 5 / 5

Parallel Seq Scan on "content_asset" "a" (cost=0.00..35,168.48 rows=18,196 width=41) (actual time=0.031..56.357 rows=14,423 loops=5)

  • Filter: ((NOT "ls_asset") AND ("end" < CURRENT_TIMESTAMP))
  • Rows Removed by Filter: 43,511
6. 86.540 86.540 ↓ 0.0 0 72,117 / 5

Index Only Scan using "rsstuff_rsunboundrecording_asset_id_ebfb7dd1" on "rsstuff_rsunboundrecording" "ru" (cost=0.55..2.15 rows=57 width=4) (actual time=0.006..0.006 rows=0 loops=72,117)

  • Index Cond: ("asset_id" = "a"."id")
  • Heap Fetches: 4,180
7. 33.178 33.178 ↓ 0.0 0 41,473 / 5

Index Only Scan using "rsstuff_rsrecording_51c6d5db" on "rsstuff_rsrecording" "r" (cost=0.56..4.75 rows=103 width=4) (actual time=0.004..0.004 rows=0 loops=41,473)

  • Index Cond: ("asset_id" = "a"."id")
  • Heap Fetches: 1,253
8. 0.384 1.291 ↑ 1.0 1,799 5 / 5

Hash (cost=85.99..85.99 rows=1,799 width=27) (actual time=1.291..1.291 rows=1,799 loops=5)

  • Buckets: 2,048 Batches: 1 Memory Usage: 124kB
9. 0.907 0.907 ↑ 1.0 1,799 5 / 5

Seq Scan on "content_channel" "c" (cost=0.00..85.99 rows=1,799 width=27) (actual time=0.027..0.907 rows=1,799 loops=5)