explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rl9Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.57..6,921,877.43 rows=333,615 width=337) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..6,887,515.93 rows=139,006 width=337) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on revision_2018 r (cost=0.00..2,936,092.46 rows=488,998 width=265) (actual rows= loops=)

  • Filter: ((NOT empty) AND (NOT inactive) AND (record_created >= '2018-01-01 00:00:00+00'::timestamp with time zone) AND (record_created <= '2018-02-01 00:00:00+00'::timestamp with time zone))
4. 0.000 0.000 ↓ 0.0

Index Scan using asset_pkey on asset a (cost=0.57..8.07 rows=1 width=125) (actual rows= loops=)

  • Index Cond: ((id)::text = (r.asset_id)::text)
  • Filter: ((NOT inactive) AND (((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) OR ((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) OR ((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) OR ((category)::text = ANY ('{3d:bite,xml:ccmod,xml:prescription,doc:mtp-metadata}'::text[])) OR ((category)::text = ANY ('{3d:mtp-raw,3d:treatment}'::text[]))) AND ((((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) AND r.sent_to_validation AND r.validation_pass) OR (((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) AND (NOT r.sent_to_validation) AND (r.validation_pass IS NULL) AND (NOT r.manufactured) AND ((r.upload_author)::text = 'acs_migration_user'::text) AND ('QS_state=waitingfordoctorapproval'::text = ANY ((r.tags)::text[]))) OR (((category)::text = ANY ('{3d:treatment,3d:retainer}'::text[])) AND (NOT r.sent_to_validation) AND (r.validation_pass IS NULL) AND r.manufactured AND ((r.upload_author)::text = 'acs_migration_user'::text) AND ('QS_state=readyforsla'::text = ANY ((r.tags)::text[]))) OR ((category)::text = ANY ('{3d:bite,xml:ccmod,xml:prescription,doc:mtp-metadata}'::text[])) OR (((category)::text = ANY ('{3d:mtp-raw,3d:treatment}'::text[])) AND ((NOT r.sent_to_validation) OR (r.validation_pass IS NULL)) AND ((r.upload_author)::text = 'tpcompute_auto_system'::text))))