explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4LYM

Settings
# exclusive inclusive rows x rows loops node
1. 0.362 3.132 ↓ 0.0 0 1

Insert on hiring_process.candidates (cost=1.05..7.38 rows=1 width=670) (actual time=3.132..3.132 rows=0 loops=1)

2. 0.012 2.770 ↑ 1.0 1 1

Subquery Scan on *SELECT* (cost=1.05..7.38 rows=1 width=670) (actual time=2.769..2.770 rows=1 loops=1)

  • Output: "*SELECT*".nextval, "*SELECT*".get_random_text_hiragana, "*SELECT*".get_random_text_katakana, "*SELECT*".get_random_text_latin, "*SELECT*".id, "*SELECT*".int4, "*SELECT*".get_randominteger_from_table, "*SELECT*".get_randominteger_from_table_1, "*SELECT*".get_randominteger_from_table_2, "*SELECT*".get_randominteger_from_table_3, "*SELECT*".get_random_number_text, "*SELECT*".get_random_number_latin, "*SELECT*".get_random_text, "*SELECT*".get_random_text_1, "*SELECT*".get_random_text_2, "*SELECT*".get_random_number_text_1, "*SELECT*".get_random_number_text_2, "*SELECT*".get_random_text_3, "*SELECT*".get_random_text_4, "*SELECT*".now, "*SELECT*".get_random_text_5, "*SELECT*".get_random_text_6, "*SELECT*".get_random_text_7, "*SELECT*".get_random_text_8, "*SELECT*".get_random_text_9, "*SELECT*".get_random_text_10, "*SELECT*".get_random_text_11, "*SELECT*".get_random_text_12, "*SELECT*".now_1, "*SELECT*".now_2, "*SELECT*".get_random_number_latin_1
3. 2.733 2.758 ↑ 1.0 1 1

Result (cost=1.05..7.33 rows=1 width=0) (actual time=2.758..2.758 rows=1 loops=1)

  • Output: nextval('hiring_process.candidate_id'::regclass), get_random_text_hiragana(20), get_random_text_katakana(20), get_random_text_latin(20), $0, ((random() * 2::double precision))::integer, get_randominteger_from_table('entry.current_employment_type'::text, 'current_employment_type_id'::text), get_randominteger_from_table('entry.entry_route'::text, 'entry_route_id'::text), get_randominteger_from_table('entry.entry_device'::text, 'device_id'::text), get_randominteger_from_table('entry.media'::text, 'media_id'::text), get_random_number_text(7), get_random_number_latin(2), get_random_text(20), get_random_text(20), get_random_text(20), get_random_number_text(10), get_random_number_text(10), get_random_text(20), get_random_text(20), now(), get_random_text(20), get_random_text(20), get_random_text(20), get_random_text(20), get_random_text(20), get_random_text(20), get_random_text(20), get_random_text(10), now(), now(), get_random_number_latin(2)
4.          

Initplan (forResult)

5. 0.002 0.025 ↑ 1.0 1 1

Limit (cost=1.05..1.05 rows=1 width=2) (actual time=0.025..0.025 rows=1 loops=1)

  • Output: genders.id, (random())
6. 0.019 0.023 ↑ 3.0 1 1

Sort (cost=1.05..1.06 rows=3 width=2) (actual time=0.023..0.023 rows=1 loops=1)

  • Output: genders.id, (random())
  • Sort Key: (random())
  • Sort Method: top-N heapsort Memory: 25kB
7. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on entry.genders (cost=0.00..1.04 rows=3 width=2) (actual time=0.003..0.004 rows=3 loops=1)

  • Output: genders.id, random()